Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Remove Delegation Warning for more then 5000 items of the sharepoint list

(0) ShareShare
ReportReport
Posted on by 4

Hii

I am using SharePoint list in making a management system with the list data of more than 5000. In which I am able to fetch the data and show them on my PowerApps but when it comes to implementation of the functions such as count, sum, average etc. in that part I am getting error of delegation. Can you help us in removing that error from my application.

Thank You

Categories:
  • EddieE Profile Picture
    EddieE 4,641 on at
    Re: Remove Delegation Warning for more then 5000 items of the sharepoint list

    @Satya121 

    Sure, but I need to know the code you are using to help further. Please post it in a code window ie (</>) for me to have a look at

  • Satya121 Profile Picture
    Satya121 4 on at
    Re: Remove Delegation Warning for more then 5000 items of the sharepoint list

    Hii EddieE 

    I have implemented the same code as you told in chat but it showing error in that. Can you please help me in other way.

     

  • EddieE Profile Picture
    EddieE 4,641 on at
    Re: Remove Delegation Warning for more then 5000 items of the sharepoint list

    @WarrenBelz 
    Sorry, was halfway through typing a response then saw that you had replied ... thought I'd reply anyway lol

    @Satya121 

    As  Warren says, these functions cannot be delegated to SharePoint. Another way around this is to use filtering. If, for example, your list has a column that stores data where filtering on this field will always return less than 2000 items, then you can do something like this.

     

    Assume your field is called 'Region' and is of type Text:

    With(
     {
     // note, each filter must return <2000 records for this method to work
     wRegion1: Filter(ashish_5011, Region = "Region1"), 
     wRegion2: Filter(ashish_5011, Region = "Region2"),
     wRegion3: Filter(ashish_5011, Region = "Region3")
     },
     Sum( wRegion1, 'Number of units') + Sum( wRegion2, 'Number of units') + Sum( wRegion3, 'Number of units') & " 
    Total Assets"
    )

     

     

  • WarrenBelz Profile Picture
    WarrenBelz 145,508 on at
    Re: Remove Delegation Warning for more then 5000 items of the sharepoint list

    @Satya121 

    I cannot see your complete code (please post in Text), but if your question is whether you can Sum/Average/Count these in a Delegable manner, then the answer is that you cannot unless you start making big collections - I have a  blog on this if it helps (please note the comment on Shadow ID Field in particular).

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard