List Box Interface Tool Issue

[KrisManns]

In the attached workflow I am trying to configure a list box interface tool to allow for all of the following scenarios:

- If I select the state of WI in the list box I then I want all lines from the Text Input that contains WI to flow through the true anchor of the filter

- If I select WI, CA, and VA in the list box then I want all lines from the Tax Input that contains WI, CA or VA to flow through the true anchor of the filter.

- If I select all states in the list box then I want all the lines of the text box to flow through the true anchor of the filter.

How can I configure the interface tool to allow for all of these options?  Should I use a macro?

[Pilsner]

Hello @KrisManns 

One way to tackle this would involve using the list box to update a separate text input. Then use a text-to-columns tool to parse the input out to one state per row. This can then be used as a lookup table using a combination of the find and replace plus a filter tool.

I have attached the workflow below.

Please let me know how you get on or if you have any questions.

Regards - Pilsner

[OTrieger]

@KrisManns 

What you will need to do is to create a list from your selection and then use it as a variable in the Filter Tool

The use of in or not in are reflecting to a list

[State] in ("WI","CA","VA")

So this is your list (items 1,item 2,item 3)

So what you need to do is creating a list from the incoming selection of the Box List and the you can use it as a variable in the formula

[State] in ([list])

[KrisManns]

I incorporated your idea into my workflow and it now works as expected.  Thank you for the suggestions!

[OTrieger]

😎