How to dynamically populate dropdown list tool based on xls input?

I figured that the example I'm attaching below should work, but it doesn't. Dropdown list options stay hardcoded to the options that were present when the workflow was being built, instead of changing according to input excel sheet (try editing the attached excel to add an extra line with a new currency/amount and it won't update).

Any ideas?

DropdownTest.7z

Workflow

Accepted answers

joshuaburkhow

Ahhh @AkisM yes totally missed that 😉

So the only way I know to make this work the way where you have a user give a file and then you populate the dropdown list is to do it using chained apps. From the user pov it wouldn't be very different. You would have your first app capture the file and get the currencies like you are doing then the second app would choose from them and do the output. Make sense?

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Hope this helps!

All comments

joshuaburkhow

Hi @AkisM

Looks like it you might not have it configured correctly. You need to select your action tool. Click once on the Expression line so it's selected and then check the box below for "Replace a specific string" and then only put the value (not quotes or anything else) that you want replaced. Like this:

AkisM

Hi @joshuaburkhow , I think you may have misunderstood the issue. My issue isn't that the dropdown list doesn't change the filter correctly. It does that fine. My issue is that the dropdown list options don't change according to the sheet selected. If the input sheet has 7 different currencies instead of 3, the dropdown list should have 7 different options as well.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703