Drop down from excel column

Gbergero

I am a new user and have searched and read many post, but cannot seem to get a solution that works.

I have an excel list that I would like the user to select a value from a column.

My sample excel data looks like:

Collector Balance
Kermit 10.00
Grouch 20.00
Chef 1,000.00

I attached my test...I am getting all records even if I select just one when running as app.

If the user selects Kermit I would like the result to be only for Kermit.

Thank you for taking the time to review.

Drop down test.yxmd

Developer Tools

Accepted answers

atcodedog05

Hi @Gbergero

On the same lines of @marcusblackhill

You can give this a check too. If required.

Drop down test (1).yxmd

marcusblackhill

Ok, so try do this:

replece sort tool by filter tool
in filter select the collector field, equal and place something just to be a placeholder, can be only "a"
link the action tool to the filter
in action you put to replace the "a" value and will works

You're trying to use the sort, that tool just to sort of the records, to you get part of the records only, based in something, need to use filter tool.