Analytical App - Drop Down Dynamic input - Chained app

[Jo-B]

Dear all, 

I struggling with the following problem. 

- I have a list of users requesting access. Those data are stored in an Excel file. The requestors are collected via an analytical app. This works fine.

- In the second step I want to have the actual list of requestors (David and Garath) as a dynamic input for the drop down tool. 

I have understood, I need to set up a chained app. The first one is updating a helper file into the format:  Name & Value. 

Name	Value
David	0
Garath	0

And in the second app I need to select the option "External Source".

All those steps are working fine. 

However the next step does not work, when connecting it to my filter. What is not correct in my workflow? It always gives me a false. 

Your help is highly appreciated! 🙂

[marcusblackhill]

Hey @Jo-B !

First of all, like a tip for you, a good practice to you can find problems in that UI cases, is to use the debug mode. You can press the shortcut ctrl+alt+d to open interface option and take the second option of the left, there you can select in your UI to create a new workflow with the values you choose of the UI, that always help me a lot!

So, back to your issue, I think the problem is how your action update the filter, because if I'm not wrong the output of your dropdown will be like "option1=True, option2=False, option3=False" instead of the option itself, so you need to update you value in filter to get the options equal true, maybe by regex formula.

[Jo-B · Accepted solution]

Hi @marcusblackhill 

I think you have guided me to the right direction! 🙂

The issue was that filter was working on the Value column and not on the name column. Therefore I entered in my pre-workflow the formula: Value=name

Than I changed the filter: [Value]= 'Johanna' . So the action was working on the value and not on the name. 

Many thanks for the input! 🙂

[marcusblackhill]

Nice! @Jo-B 

Happy to help! So if already worked, mark the answer like accepted to close the issue.

Good developments!

[Siddhantpattnaik]

I am trying to use the chained analytical app , everything is working fine except for while writing to the output file getting error as "The file " " must contain a Name and a Value field . While I am having only 2 rows through the cross tab. Please help me with a solution.