Unanswered

Retrive more than 2000 records from sharepoint List

(0) Share

Report

Posted on by abhishek_123

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

Categories:

Power Apps Pro Dev & ISV

All responses (5)

Answers (0)

Sort by

Mr-Dang-MSFT Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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.
abhishek_123 56 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Ben Thompson 1,400 on at

Like
a
(3)

Report
Copy link

Link copied!

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
abhishek_123 56 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

I believe the limitation is in PowerApps - so changing SP to CDS/SQL will not be of help here?