Unanswered

PowerApps Delegation and the 2000 item limit

(0) Share

Report

Posted on by Ghada Mehrez

257

I have created A timesheet power application connected to the Sharepoint list as the data source, the issue here in power apps the max limit to see up to 2000 records and the users cannot view any records that exceeds these records, any solution how to increase the records limit.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

rsaikrishna

3,703 on at

Like (0)

Report

@gme-eg

We cannot increase the number beyond 2000. When Power App queries for the information, Power App does not process the data but it passes the query to the data source for processing and returns the data.

Depending on your data source, some of the operations are not supported by the datasource. Due to that, we will run into delegation warnings in the Power App.

All the blue line errors, which shows up in the Power Apps Health Checker as warnings must be resolved.

All the delegation warnings related to the SP lists which contains (or will contain) more than 2000 should be resolved by adjusting the formulas.

Here is the article:

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

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

C-Papa 1,836 on at

Like (0)

Report

We had a similar issue, you are best filtering the timesheet entries by date, for example, one person will not submit 2000 timesheets in one week. If you want to look at the data globally for the whole business, for the whole year, PowerBI would be a better option but you have to consider the refresh rates. The above approach would allow you to view 2000 timesheet lines in total. One alternative is to use a forall formula to go through each member of staff and collect all of their records individually and store them in a variable / collection. this way you could have 2000 member of staff and 2000 timesheets each.

Was this reply helpful? Yes No