Interface Tool -- File Browse -- Automatically Choosing Excel Sheet

[smoskowitz]

Hello All --

I am creating a workflow that has the ability to choose the file a user needs to run through the workflow (using the File/Browse tool). When you choose a file, the next step is to choose the sheet (this is an Excel file).

All the files need to use the same sheet. I was wondering if there is a way to have a user choose the file, and it automatically chooses the sheet the need. In this case, the sheets name is simply IPG.

Thanks,

Seth

[bcadwell]

I'm having this issue as well. The problem is that the behavior is different in designer and the gallery. You can make it work in the gallery if you configure the update value section to replace the string that includes the sheet name. If you're testing in designer, the replacement can't include the sheet name. So, any app you design will error either in the gallery or designer. You can have one or the other, but not both.