Hello, I am trying to pull the user's selected excel filepath and selected tab using the chained apps below and would appreciate any kind of help or guidance: * Chained App 1: The user selects an excel file allowing the file path and corresponding sheets to be recorded as output (alteryx DB file). * Chained App 2: The output from App 1 (alteryx DB file with sheets/tabs from the selected file) is able to be selected via dropdown. The selected sheet is then recorded. Issue: The input used for App 2 is not updated when the apps are chained. In other words, the result from App 1 is correct but does not update as the input for App 2 unless it is run separately. Please use the "MonthTest" file as a sample input file and update the local filepath as necessary. Thanks! App 2 - Tab Selection.yxwz App 1 - File Selection.yxwz MonthTest.xlsx

Chained App 1's Output Not Being Updated When Used as Chained App 2's Input

Hello, I am trying to pull the user's selected excel filepath and selected tab using the chained apps below and would appreciate any kind of help or guidance:

Chained App 1: The user selects an excel file allowing the file path and corresponding sheets to be recorded as output (alteryx DB file).

Chained App 2: The output from App 1 (alteryx DB file with sheets/tabs from the selected file) is able to be selected via dropdown. The selected sheet is then recorded.

Issue: The input used for App 2 is not updated when the apps are chained. In other words, the result from App 1 is correct but does not update as the input for App 2 unless it is run separately.

Please use the "MonthTest" file as a sample input file and update the local filepath as necessary.

Thanks!

App 2 - Tab Selection.yxwz

App 1 - File Selection.yxwz

MonthTest.xlsx

Input

App Builder

Accepted answers

SPetrie

Sorry about that. I tweaked App1 a bit and forgot to make sure the action tool was also updated properly.

Try this version. It should work for other excel files.

App 1 - File Selection.yxzp

All comments

SPetrie

You are using the yxdb to create a new dropdown at run time which is where the issue is happening.

Your yxdb already has the name/value pairs in it, so you only need to reference the file and dont need to create the dropdown items in the flow.

Try this version and see how it goes.

App 1 - File Selection.yxzp

courtneyq

Thank you for a calling out the dropdown issue. The updated workflow you provided does work perfectly for the sample input file of "MonthTest.xlsx" although it will not pull down accurate sheet names for other excel files since I was hoping to use this for other files as well.

SPetrie

Sorry about that. I tweaked App1 a bit and forgot to make sure the action tool was also updated properly.

Try this version. It should work for other excel files.

App 1 - File Selection.yxzp

courtneyq

Perfect, thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703