Get more than 500 records in Combo Box

(0) Share

Report

Posted on by venka91

1,118

👋 Hello everyone,

I’m working on a scenario where I want to filter a SharePoint list based on a Choice column (Status) and display the filtered titles in a ComboBox for user selection. My current formula is:

Distinct(Filter(SharePointList, Status.Value = "Closed"), Title)

This shows the Title values for records with a "Closed" status — but only up to 500 items due to the delegation limit in Power Apps. Ideally, I want users to be able to search and select any matching Title, similar to the behavior in Office 365's user lookup, which queries against all results, not just the first 500.

🎯 What I’m trying to achieve:

Please provide your inputs.

Display all matching Titles where Status = "Closed"

Enable search-based filtering within the ComboBox, beyond delegation limits

Avoid delegation warnings when using StartsWith(Self.SearchText, Status.Value) or similar patterns

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

WarrenBelz 148,876 Most Valuable Professional on at

Like (1)

Report

Get more than 500 records in Combo Box

Hi @venka91,

I will also add that this bog of mine for getting distinct values from large lists may also be useful to you.

Please click 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 giving it a Like.
Visit my blog Practical Power Apps LinkedIn Buy me a coffee
Pstork1 67,109 Most Valuable Professional on at

Like (1)

Report

Get more than 500 records in Combo Box

The 500 limit is a hard coded limit on the Combo Box control. It is not due to delegation. There is no way to change that limit. But the Combo Box has a built in capability to Search on Specific fields in the data source. Just Enable isSearchable and set the SearchFields property of the Combo Box to Title. Read more here: Combo box control in Power Apps - Power Apps | Microsoft Learn

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog