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?
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.
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.
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.
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:
More details about exporting data from SharePoint List to Excel, please check the following article:
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:
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!