SOLVED
Analytic App to Update Value Based on Sheet Name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kristinaheuer
7 - Meteor
01-12-2022
12:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
Solved! Go to Solution.
2 REPLIES 2
17 - Castor
01-12-2022
01:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
01-12-2022
07:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You are the best! Thanks, Fernando. 🙂
