Answered

How much data volume can Power App handle (Sharepoint list as data source)

Like (0) Share

Report

Posted on 16 Jan 2024 01:46:26 by adrianchy231319

Hi guys,

We are building building a budget tracking application using Power Apps with the data source from Sharepoint list. We did get some feedback that there will be some limitations on the data volume.

We would like to know:
1. What is the maximum data volume limit that Power Apps can handle when using a SharePoint list as a data source? While it's known that Power Apps has a maximum row limit of 2000 rows,

2. Is this limitation specifically related to querying or does it also apply to the total dataset volume when connected to a SharePoint list?

BR

J

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

WarrenBelz 148,894 Most Valuable Professional on 16 Jan 2024 at 02:49:05

Like (0)

Report
Re: How much data volume can Power App handle (Sharepoint list as data source)

Hi @adrianchy231319 ,

I can give you some "limits" where certain things apply, but are generable manageable

2,000 rows is the Data Row Limit for locally-processed queries in Power Apps, which applies to non-Delegable queries (SharePoint will not do the work for you) and some other functions such as Collections and some queries using power apps only functions.

5,000 Rows in SharePoint requires all fields involved in queries (you are allowed 20 per list) to be indexed in SharePoint.

SharePoint will technically hold 33 million records, but would get quite slow anywhere near that limit. Several hundred K however is not an issue generally,

A Delegable query with SharePoint can be exercised on any number of records (keeping in mind the note above) and will return all matching records.

I have a blog on Delegation that may be useful to you.

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
v-yueyun-msft on 16 Jan 2024 at 02:48:38

Like (0)

Report

Re: How much data volume can Power App handle (Sharepoint list as data source)

HI , @adrianchy231319
The amount of data that can be processed in a Power App is 500-2000.
However, more than 2000 rows of data can be loaded in the gallery through pagination, which is what we call delegation. It does so by scrolling down to load 100 pieces of data at a time.
For more information, you can refer to :
Understand delegation in a canvas app - Power Apps | Microsoft Learn

For the SharePoint List , it is a delegable data source. But you need to use the delegable functions in Gallery Items so that you can load more than 2000 rows in Power Apps.
For more information, you can refer to :
Bing Videos

Best Regards,
Yueyun Zhang