Results based on dropdown

[ppatane]

I want to be able to select an individual from a drop-down list and receive back a list of their projects.  I'd tried the Join tool to no avail, so I am tring this workaround, which to me, is logical, but I get no results. If I remove the filter tool, I get the expected results of the user selected on every line next to the name and value fields.(1st screenshot)  When I add a simple filter, I get nothing back. (2nd screenshot)  I'm sure there is a simple solution that I am not seeing.

[alexnajm · Accepted solution]

I think you may be overcomplicating it - why can't the users just directly affect the filter?

[apathetichell]

@ppatane ---> use a filter in custom mode. [User]in("Perez, Manuel') ---> configure listbox in list mode -->
delimit to look like " "," "

use action tool in update value. put "Perez, Manuel" in replace specific string---> include quotes.. click box.. run via wand.

[alexnajm]

@apathetichell example provided does exactly that 😊

[binuacs]

@ppatane updated the workflow to dynamically load the user name from the input file

[ppatane]

@binuacs quite complex (to me), but awesome result!