Unanswered

Combo box not searching records beyond 500

(0) Share

Report

Posted on by Abhishek Gawde

Hello Power People!

I am facing an issue with regards to combo box in a canvas Power App. The combo box is not able to search records beyond 500 records. I have set the data row limit to 2000, so i assume this limit is on the combo box, is there any work around for such a scenario. The combo box is used to search for employees in order to assign a role.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @abhishekgawde ,

Can you please share the Items property of the combo-box? What data source are you using?

Was this reply helpful? Yes No
Abhishek Gawde 96 on at

Like (0)

Report

Hi @BCBuizer

I am using Dataverse as the source.

Filter(Users, 'Users (Views)'.'Enabled Users')
The IsSearchable property is set to true

I also tested with the following formula
ForAll(Sequence(2100),Value);

The displayed records and searchable records are both limited to 500

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @abhishekgawde ,

Are you sure you are using a combo box? I just tested with Sequence(5000) and could see them all:

Dropdown controls on the other hand do have a documented limit for 500 items: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-drop-down#description

Was this reply helpful? Yes No
Abhishek Gawde 96 on at

Like (0)

Report

hello @BCBuizer

thank you for looking into it.

Yes, I am using combo box. tried with both the modern control and the classic one. Strangely, the drop down control is now missing in the studio for me. I also tried changing the authoring version of the power apps studio.

Capture1.PNG

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Are you making a standard Power App, or are you perhaps using Power Apps in Teams or editing a SharePoint form? These things can make a difference, so please share all the details.

Was this reply helpful? Yes No
Abhishek Gawde 96 on at

Like (0)

Report

It is a Custom Page actually!

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @abhishekgawde ,

That seems to be the issue then. Despite that all of these scenarios are branded as Power Apps, behind the scenes there are some differences between them.

Perhaps you can use cascading comboboxes or a search function to limit the amount of items in the combo box, or use a gallery instead (which will come with it's own limitations).

Was this reply helpful? Yes No
IanJB 93 on at

Like (1)

Report

I hope there are near-term plans to have this corrected for Custom Pages. Bit of a drag to not be able to use the native search function on the combo box in an environment where you're guaranteed to be using Dataverse sources (and likely present more than the 500 limit).

Was this reply helpful? Yes No