cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gme-eg
Helper IV
Helper IV

PowerApps Delegation and the 2000 item limit

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.

1 ACCEPTED SOLUTION

Accepted Solutions
rsaikrishna
Dual Super User
Dual Super User

@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 SolutionMarking 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.

View solution in original post

2 REPLIES 2
rsaikrishna
Dual Super User
Dual Super User

@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 SolutionMarking 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.

View solution in original post

C-Papa
Resolver II
Resolver II

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. 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Top Solution Authors
Top Kudoed Authors
Users online (89,336)