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 / Delegation Warning in ...
Power Apps
Answered

Delegation Warning in Patch (SPO)

(0) ShareShare
ReportReport
Posted on by 148

I have this formula in a control:

AaronRichardson_0-1598458433343.png

I'm patching a SPO list, filtering down to the record I need to patch, and using First to made the filtered item a record. I've patched this way before without getting the delegation warning, so I'm confused why I'm getting it here.

 

Logically, since the Filter function is delegable, the fact that the First function isn't shouldn't matter, right? Ultimately I just want to update my list without worrying about delegation limits, and I thought that this method achieved that until I got this warning today. Perhaps there's a better way to do this? Any recommendations or feedback is welcome!

Categories:
  • Verified answer
    RezaDorrani Profile Picture
    12,145 on at

    Hi @AaronRichardson 

     

    Replace First(Filter wih Lookup

     

    Lookup does the same thing in a much more efficient way and is delegable

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • AaronRichardson Profile Picture
    148 on at

    That works! Thanks for replying! 

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 July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 402 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 296 Most Valuable Professional

Last 30 days Overall leaderboard