cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhishek_123
Helper I
Helper I

Retrive more than 2000 records from sharepoint List

Please let know the workaround to retrive more than 2000 records from sharepoint list.
I tried using multiple collect and then combine those with another collect but powerapps only retrives first 2000 records.
Ex:
Collect(Col_name1,Filter(SP_list,ID>=1 && ID<2000)); Collect(Col_name2,Filter(SP_list,ID>=2000 && ID<4000));
Collect(Main_Col, Col_name1,Col_name2)

I also tried using filter with valid delegation but that too has the same issue.
The SP List might hold more than 10000 records.

Thank you

4 REPLIES 4
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @abhishek_123 ,

As a best practice, an app works best when it is lightweight and operates on the minimum necessary data to take an action. 

 

If you need to see all of the data or large amounts of data, that's more of a visualization use case and starting in Power BI may make more sense. From there, you can embed an app for taking action on data that has been sliced.

 

I would advise against recreating SharePoint or SQL inside of Power Apps. If you need to view the entire back end, those experiences already exist on SharePoint and SSMS. Instead consider sharing more about what you need to filter and the community here can help you write a good formula.

 Hi @Mr-Dang-MSFT ,
Thank you for the inputs but i wanted to filter data out and also update fields so say I have 10000 records with country column and I want to filter out data as per country: Filter(SP_list,country="CountryName")  but the powerapp filters first 2000 record but I want it to filter through all the records and return all the data with the CountryName.

The issue is that the filtering in a Power App is done after the data has been pulled from the Sharepoint list and the connection between the Power App and the Sharepoint list only retrieves the first 2000 records.

 

I know that's not what you want to hear but if you want to look at more than just the first 2000 records you will need to find a connection that can either retrieve more than the first 2000 records or a means of filtering the list within Sharepoint before returning the records 

---
If this post has answered your question please consider it for "Accept as Solution" or if it has been helpful give it a "Thumbs Up".

Hi @ben-thompson ,
Is this a limitation in sharepoint connection, If yes, can i use CDS or SQL server ?

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,325)