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.
Collect(Col_name1,Filter(SP_list,ID>=1 && ID<2000)); Collect(Col_name2,Filter(SP_list,ID>=2000 && ID<4000));
I also tried using filter with valid delegation but that too has the same issue.
The SP List might hold more than 10000 records.
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
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!