Use distinct in a dropdown from excel connector to get unique values column table

(0) Share

Report

Posted on by Charlie Martharper

237

Hi!

So what I am trying to get is the unique values from a full column of an excel. So when getting the connector into the dropdown, it gets all the values:

As you can see, it gets all the values of the table but I want to get only 1 value of each. I think I have to use Distinct but dont know how eaxctly.

Someone could help me?

Thanks!!

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 151,947 Most Valuable Professional on at

Like (2)

Report
Use distinct in a dropdown from excel connector to get unique values column table

Hi @Charlie Martharper,

Firstly, Distinct is not supported by Delegation, so you will only be able to address record numbers up to your Data Row Limit (standard 500, maximum 2,000). However if you have under this amount of records you simply need
Distinct( YourTableName, YourFieldName )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Charlie Martharper 237 on at

Like (0)

Report

Use distinct in a dropdown from excel connector to get unique values column table

Thanks you so much @WarrenBelz!!

I have visited your blog but didn't have time to read it that time. Will check it again when I have some free time for sure! It's so interesting.

Great job!

Was this reply helpful? Yes No