Record's limit of 2000

(0) Share

Report

Posted on by MH-16041639-0

Hello community,

I’m working with a Canvas App in Power Apps that uses a large SharePoint list. The app’s Data row limit is currently set to 2000, and I would like to know:

Is it possible to increase this limit beyond 2000?

If yes, where can this setting be configured in Power Apps?
If it’s not possible, could you please share best practices for filtering large SharePoint lists in Canvas Apps (delegation, indexed columns, recommended patterns, etc.)?

Thanks in advance for your guidance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

@MH-16041639-0

No — you can’t increase the 2000 limit beyond that in Canvas Apps. It by design
   •   The setting is in File → Settings → General → Data row limit, but 2000 is the maximum allowed.
   •   This limit only applies to non-delegable queries (that’s the key point).

Best practices for large SharePoint lists:
   •   Use delegable functions (like Filter, Sort, LookUp) so Power Apps queries SharePoint directly instead of pulling limited data.
   •   Ensure columns used in filters are indexed in SharePoint

Vishnu WR

LinkedIn - My Tech Space

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 ♥

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MH-16041639-0,

By way of a bit of explanation, I do not believe Microsoft have any plans to increase this (it has been the same since the start of Power Apps just under 10 years ago) as performance and integrity of data needs to be guaranteed, especially on mobile devices. The limit defines the amount of data able to be reliably processed "locally" on the device such as non-delegable queries and other things you might do with Collections.

If you use Delegable queries, they are processed by the data source server and the requested data comes back (so the device does very little work). I have a number of blogs on Delegation - the first two may be worth reading for you. You will notice in the second one, you can do "big collections" - they work, but performance takes progressively bigger hits the larger they get, both in record and field numbers (up to 4,000 is generally acceptable).

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
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @MH-16041639-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

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