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.

[atcodedog05]

Hi @Gbergero 

Can you please provide the input file so that we can run and look into the workflow. And help you out🙂

[marcusblackhill]

Hey @Gbergero !

So, do you need to filter you data by the selection picked from the drop down list? Try this change in example if is that.

Hope that helps!

[Gbergero]

Please see attached.

[Gbergero]

I was unable to open because I am using version 2020.3.5.30242 and received an error

[marcusblackhill]

Ok, try to open this attached now.

[atcodedog05 · Accepted solution]

Hi @Gbergero 

On the same lines of @marcusblackhill 

You can give this a check too. If required.

[Gbergero]

I was able to download and run as app, but the results window is blank except for headers.

[Gbergero]

That works!!!

Can you help me understand what I was missing?

[Qiu]

@Gbergero 
Basically same with @marcusblackhill , just add one Unique tool in case multiple entries for one collector.