web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / LookUp delegation warning
Power Apps
Answered

LookUp delegation warning

(0) ShareShare
ReportReport
Posted on by 35

Hi,

 

So I have a SharePoint approval list  that is now at 2000+ rows. This caused me some delegation warnings on displaying the data. What I did was to "group" the approvers, which approvers will select their initials prior to loading the data (which will then be filtered and stored in a collection to be displayed in a gallery). 

 

My data display looks like this. 2019-09-20_10-24-04.png

 

Users can tick checkboxes or the select all checkbox then click approve/reject.

 

My approve/reject formula is this:

UpdateContext({Waiting:true}); 
ForAll(
RenameColumns(Filter(gallery.AllItems, itemcheckbox.Value = true), "ID", "ID1"), Patch('SP List', 
LookUp('SP List', ID = ID1), 
{'Approval Status':{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value:"Rejected"}}));
 UpdateContext({Waiting:false}); 
Navigate(SuccessScreen)

This works in my other approval lists that doesn't have 2000+ rows, so I was thinking it had something to do with the 'remedy' I did for this particular list. Appreciate any suggestion to help me in executing the approve/reject button. Thank you!!

Categories:
I have the same question (0)
  • RezaDorrani Profile Picture
    12,145 on at

     

    Hi @anmdf 

     

    Tried same scenario as yours but not getting any delegation warning on the button click (I event set my delegation limit to 5 and tested)

     

    Capture.PNG

     

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Verified answer
    anmdf Profile Picture
    35 on at

    Thanks for the reply!

     

    I figured the issue was not with the delegation hehe. The gallery was in a collection and not the SharePoint list itself, so I had to edit the refreshes to refresh the collection in order to see the items being approved. Thank you!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard