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 / Avoiding delegation us...
Power Apps
Unanswered

Avoiding delegation using a gallery

(0) ShareShare
ReportReport
Posted on by 51

Hi guys. So ive been having alot of issues with delegation using sharepoint as a database. However i stumbled upon a hack that ensures i dont get delegation warnings.. For instance i used this script below

 

Sort(SPList, NumberColumn, descending)

 

to get the gallery populated based on certain number field on sharepoint in descending order. Im getting a delegation ⚠️ warning prolly because sort function using number column is not delegable. However i was able to create 2 galleries.

 

1st gallery called Gallery1 with item propery of SPList, then 2nd gallery called Gallery2. On the gallery2 item property, i used the formula below

 

sort(Gallery1.Allitems, NumberColumn, Descending)

 

and this did not throw any delegation error.

I just wanted to know if i was truly able to bypass this delegation issue using this method

Categories:
I have the same question (0)
  • C-Papa Profile Picture
    1,836 on at

    Hi, no you are just sorting the items in a gallery that is already collected into PowerApps. Sort is delegable so this is not your issue, can you post the rest of your code. 

     

    fyi - SharePoint delegation improvements | Microsoft Power Apps

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Adding to @C-Papa comment, Sort is delegable using a number column, so that shouldn't be causing your issue. The screenshot below is from the Power Apps docs for SharePoint.

    Capture.PNG

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard