Filter for multiple values

Hi, I am trying to build a filter option for the server to let the end user pick as many (or as few) options from a list as they would like. I am currently using a list box, action, and filter tool (attached images below). However, when I run it as an app, the filter is not working and all are flowing. Is there a way to modify this?

Action Box.PNG

List Box.PNG

Filter.PNG

Workflow

Developer Tools

Server

Accepted answers

SPetrie

Are you able to share the app without any confidential info?

I cant think of anything else that would cause it without looking at how its actually running.

You can compare it to this test one I made where it is filtering the data appropriately.

TestList.yxwz

All comments

SPetrie

In the action tool, get rid of the parenthesis. You only want to replace the values inside them. Im not seeing anything strange beyond that.

adam_rafael_18

Modified for that and still running into the same issue - any other recommendations?

SPetrie

Are you able to share the app without any confidential info?

I cant think of anything else that would cause it without looking at how its actually running.

You can compare it to this test one I made where it is filtering the data appropriately.

TestList.yxwz

adam_rafael_18

Thank you! I honestly am unsure what was off on my end, but I recreated it and it now works.

adam_rafael_18

Hi, one quick follow up - is there a way to pull the filter the user selected? For example, if the user filters on company C, is there a way to make that part of the output? Goal is to build a control incase someone says "I filtered on A and B but only B appeared" but we can show "hey you only selected B"?

SPetrie

You can. Its pretty similar to the original flow, you just add another action tool to update a formula tool with the selected values.

One word of caution. The selected items it outputs will be in double quotes, so whatever string you create that will have the replaced values needs to be single quoted or you will get operation errors.

TestList.yxwz

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703