Unanswered

How does list view threshold limit affect Power Apps application?

(0) Share

Report

Posted on by Soumodip

Hi,

If the threshold limit of list view in SharePoint Online list exceeds (that is number of items exceeds 5000), will I still be able to enter data to the list from my Power Apps application?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

sayyed007amir 357 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes you can store up to 30 Million items in list as per Microsoft documentation.
Ref: Manage Large list and Libraries

Threshold limit means: it will show you 5000 items at a time only.
I even have a list which contains 25k+ records.
Soumodip 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Will I be able to export such large lists to excel?
Also, how to view the items in case threshold limit exceeds (I have used indexed columns)
I am really new to SP Online and Power Apps, sorry if the questions sounds juvenile .
Thanks for the help.
sayyed007amir 357 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't have much idea with importing Excel, but you can look at that article it may help you: Handle Excel data queries
You can use filters to view data.
A very good blog on this topic.
Reference: How to overcome SharePoint 5000 item limit threshold

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Soumodip ,

Do you want to export your SP List into Excel?

Do you want to use Excel as data source within your canvas app?

For exporting your SP List into Excel, the answer is YES, you can. Currently, within a Excel file, you could own 1,048,576 rows by 16,384 columns in total.

Please check the following article about the known limits in Excel:
https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

More details about exporting data from SharePoint List to Excel, please check the following article:

https://sharepointmaven.com/export-sharepoint-excel/

If you want to use Excel table as data source in your canvas app, I think you would face Delegation issue in your canvas app. The Excel file is not a Delegable data source in canvas app, so it could only retrieve first 2000 records from your Excel table at most. In other words, if there are 5000 records in your Excel, you could only process first 2000 records in your canvas app at most.

More details about the Delegation in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Best regards,