Analytic App to Update Value Based on Sheet Name

[kristinaheuer]

I have an Excel file with multiple sheet names. I would like for my business users to use our Gallery to select which process to run based on the selected sheet name. The Designer process runs without issues, but the Gallery tells me that it cannot read the sheet name. See workflow attached and error message below:

[fmvizcaino · Accepted solution]

Hi @kristinaheuer ,

Happy to see you here! 😁

When you use a list box, the output is a list of true and false. Something like this:

CCOM Main=True,CCOM Best Buyer=False,CCOM Prospects=False,CCOM Suppression=False,CCOM Hotlines=False

In your example, you need to use a drop-down tool.

Best,

Fernando Vizcaino

[kristinaheuer]

You are the best! Thanks, Fernando. 🙂