Interface tool help

[SahilArora3139]

Hello Alteryx Community,

I'm currently working on an Alteryx workflow and need some assistance . My goal is to create a dynamic search feature where, upon entering a name in a textbox or dynamic field, the workflow will retrieve all related data associated with that person from a dataset. The challenge is that the name could be present in any column, not just a specific one.

For instance, if I input the name "Peter H.," the workflow should search across all columns and, if found, it should

display the corresponding 'Req ID' and other related details from those rows.

Here's a brief overview of what my dataset looks like: 

(attaching the ss)

I am seeking guidance on how to structure this workflow to effectively search across multiple columns and pull all relevant information based on the input name. Any insights, tools, or functions within Alteryx that could facilitate this would be highly appreciated.

Thank you all in advance

[alexnajm]

I think this is being answered on another thread?

if you want to manually enter values, a Text Box is likely your move. If you want to select a SINGLE value from a list, a Drop Down will work. If you want to select MULTIPLE values from a list, a List Box is your best bet. 

if you do go down the Drop Down / List Box route, you’ll have to consider how the lists get populated. For example, manually is the most common but you could create a chained app to make the names from the input file and populate the list. This should help: https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Good luck!