Multiple Interface Tools

[Avi6999]

Hi Alteryx Community,
I'm working on a dynamic workflow where I use interface tools to pass user inputs into a SQL WHERE clause. I have 4 parameters, 3 are Text Boxes and 1 is a List Box. The dynamic WHERE clause works perfectly when I use a Text Box for the fourth parameter. However, when I switch to a List Box for the fourth parameter, the results are not being pulled even though the formatting seems correct.

[pstrasser]

Hello! I am thinking it may be due to how textboxes and list boxes behave differently. A couple things that i would do to troubleshoot the problem is to use the interface designer to run your input via a Debug workflow: 

You can edit how the list box outputs values in the list box configuration pane. Start with this and let me know if you have any follow up questions. 

[apathetichell · Accepted solution]

@pstrasser is correct... 1) for a listbox your action tool should be configured in list mode. and use " "," " as your separators. 

2) when you are configuring to replace something in your action tool --- use replace a specific string --- and include the quotes --- you are replacing a full list --- not just a value. I use this often with IN.

as an alternative you can configure your list tool with \n as a delimiter --- split it to  different text input. use text to columns to split to rows with \n -- and then use summarize to build. I would do this to capture errors.