Large Data binding to ComboBox

(0) Share

Report

Posted on by MS.Ragavendar

7,431 Super User 2026 Season 1

Hi @WarrenBelz,

I need to load all 4 lacs records in to combobox tried with with https://www.practicalpowerapps.com/delegation/with-statement-managing-delegation/

but its taking almost 5 mins with collecting the data, can you please share me some other ideas.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

MarkRahn 1,418 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MS.Ragavendar

I know you asked for some help from Warren and I don't know if this will help you or not...

But take a look at this post: Sequential Concurrent ForAll in Power Apps

I implemented this approach inside App → Formulas to speed up how a large collection loads. I originally used it for a Gallery, but the same pattern applies to a Combo Box.

One thing I discovered after doing a lot of work on the data‑loading logic is that the UI was refreshing while the collection was still being populated. Every incremental update caused the Gallery to redraw, which slowed everything down.

To avoid that, I loaded the data into a temporary collection first, let it finish building completely, and then copied the finished result into the collection bound to the Gallery. Once I switched to this pattern, the loading performance improved noticeably because the UI only updates once—when the final collection is assigned.

This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊

Thanks
-Mark

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MS.Ragavendar,

Also thanks @MarkRahn for the reference to @iAm_ManCat's blog post.

I have a few observations first - I assume 4 lacs means 400,000 records (sorry I am Australian we have not heard that term for a while). If that is the case, I am quite surprised that Power Apps could handle any queries on that dataset at anything other than glacial pace (I have had enough issues above about 5,000) and yes, the model I have would take quite a while for 400k records. Also searching that Combo Box with 400k records will be problematic at best.

The concurrent option may be worth adapting to your needs for testing, however you are going to have 200 collections to then join together, so not sure if that will save you time overall.

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
MarkRahn 1,418 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MS.Ragavendar

Were you able to find a workable solution?

This community is supported by individuals freely devoting their time to answer questions and provide support. They do it to let you know you are not alone. This is a community.

If someone has been able to answer your questions or solve your problem, please click Does this answer your question. This will help others who have the same question find a solution quickly via the forum search.

If someone was able to provide you with more information that moved you closer to a solution, throw them a Like. It might make their day. 😊

Thanks
-Mark

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks to @WarrenBelz my bad yes 4lac -> 400,000 you are correct. Handling large data is a bottleneck. Will the threshold of 2000 will be uplifted ?

@MarkRahn, apology for the inconvenience even with the sequential for all I found challenge in rendering the data because its repeating row kind of implementation so we have revisited the business logic in such way.

By using stored procedure we retrieve the data based on some condition rather than showing entire dataset.

Also we would be happy, If you post the similar reply to many post which we used to suggested / answered but it wont be marked as verified 😁😁

Was this reply helpful? Yes No
WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @MS.Ragavendar,

Firstly, my understanding of your question around the Data Row Limit is that Microsoft have no plans to increase it any time soon. The logic is around the capacity of the local machine (particularly mobile devices) to both store (resources) and perform queries (processing) on data "locally". As I mentioned before, 400k records locally would present very large challenges indeed.

Alternatively, when a Delegable query is sent to a data source, very little work is done by the local device - it sends off a small text query string and receives back the requested data. For performance reasons, these come back in batches of 100, however the user simply has to scroll or requery to get additional / updated data - a very efficient procees from a local resource point of view and completely transparent to the user.

Your solution of using a Stored Procedure (I assume you are using SQL) is absolutely correct and is certainly the best way of restricting the data set to what you need.

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