Dynamically update a filter based on user selection

[Mina2021]

Greetings,

I'm currently attempting to build a workflow app that complete the following activities- 

1) User upload a file (*.xlsx file)

2) User to select date range

3) User can select number of action they want to see

4)User can select the view whether it is "forward" or "Backward"

5)User can see by filtering "Inspection Type", "Contents ID" and "Transaction ID"
6)User can see a) Actions, b) both Actions & Date diff

So far, I am able to complete till 4) and currently stuck in 5). Does anyone know how we can configure the workflow to allow the filter input tool to be updated based on the options selected by the user? I already did for the Inspection Type but not able to figure out how to do for Contents ID & Transaction ID.

Thanks for all your help!

[add9880]

Hi Mina2021,

You can connect the Action tool directly to the Filter tool and configure based on a pre-defined formula.

I hope this helps

Kind regards

Anuj D.

[Mina2021]

 Hi

add9880

 I could do the 5) currently stuck in 6).

Can you see my workflow once!

[danilang]

Hi @Mina2021 

Since your original formula had a series of "or" clauses, I assume that you want to allow the user to select one or more options using a list box to dynamically update a filter.

The list box is configured like this

It generates a custom comma delimited list.  I've added the values in manually based on the what you had in your example. 

The filter is built using the IN syntax [Options] in ("Inspection Type","Contents ID","Transactions ID")

The Action replaces the text in the IN clause of the filter with the comma separated list from the List box.  The result of this is that the filter only passes through the records that the user selects.

Note that my example only includes Container 188 for your original workflow.  

Dan