Unanswered

DropDown not showing all Distinct items - Basic

(0) Share

Report

Posted on by kgiles123

224

I'm connecting a SharePoint List, ('Provider Inclusion By State' column 'State') of 658 items to a PowerApp DropDown.
Here is my formula:
Distinct(Sort('Provider Inclusion By State','State (State0)'),'State (State0)')

Not all of the states are currently showing. Please let me know what I'm doing wrong.

These are the last states in my SharePoint List:

This is the bottom of my sorted drop down.

Please and thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MaximusDecimus 281 on at

Like (2)

Report

Hey @kgiles123

Have you set your row limit to something higher than what your current SharePoint list row number is now?
This value is set as a default of 500, this can be increased to a maximum of 2000.
If yours is still set at 500 that would explain why your drop down may be missing values as anything over row 500 would be ignored.
To change this please do the below:
Click on Settings and change to Data row limit to what you need

The above would only be a temp fix - if your data grows over 2000 rows then you would need another method.

I would suggest creating another SharePoint list which stores your Distinct State values in and keep that updated and have the drop down look at that list instead.

Was this reply helpful? Yes No
kgiles123 224 on at

Like (1)

Report

That did it! Thank you so much!

Was this reply helpful? Yes No