Using List Box to update Filter with multiple selections (Analytic App)

[kanemku]

Hello,

Sorry if this is an easy solve. I've looked all over the community boards, and nothing that I've seen as a solution has solved my problem. I'm only a month into using Alteryx, so I apologize if this seems simple. 

I have an an analytic app that filters records by a project number. Based on that range of numbers, it will output a list of project managers for their respective project number. That list is then used to populate a list box that should then allow you to select one or multiple managers and have all companies tied to each manager populate an output file. 

App 1

App 2

The issue is that when I select a manager, whether it's one or multiple, nothing is output, and I don't get a list of companies for either one or multiple selections. I quite literally copied the formula from another post with this exact issue, and it doesn't work for me. I'm hoping that someone can compare the two workflows to see if I made a mistake somewhere or if there's another solution. 

I've attached the example solution that I tried to copy. It works exactly how I need it to, but that same logic in my app doesn't carry the same results. 

Sample App

The filter tool in their app just had 'Anything' in the custom filter section. I've tried that as well as what I have in my filter tool. 

Thank you all in advance.

[SPetrie · Accepted solution]

Its the name/value pair in your AvailableManagers.yxdb file causing the issue.

When they select the name in the second workflow, its giving the corresponding value to the filter tool. Brian becomes 1 and 1 doesnt match anything being passed to the filter, so you get no output.

You want your Name/Value pair to look like this

This way, the name and value match, so your filter criteria will have something to match to.

I made two small changes to App1 and was able to get it to work, no changes were necessary for App2.

Firs, the action tool was referencing a field that didnt exist, so I updated that from Project_Definition to Project_Number

Second was to remove the RecordID tool that was being use to create the value column and replace it with a formula tool to make the value column and set it to be the same as name

Once I made those changes, the workflow ran fine.

[kanemku]

Thank you so much! That was the issue and the resolution for me. I'm glad that it was something simple!