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 / Sorting Delegation War...
Power Apps
Unanswered

Sorting Delegation Warning

(0) ShareShare
ReportReport
Posted on by 1,265

I have a Sort "Distinct(Sort('Safety Good Catch Items',AssignedTo.Value,Ascending),AssignedTo.Value)" on an input for a Filter and I am receiving a Delegation Warning.

 

RJF61_1-1666183694835.png

Is there way to eliminate this issue?

Categories:
  • Ben_C Profile Picture
    on at

    Distinct is causing you a problem as its not delegable.

     

    Depending on the amount of rows you have in your data source it might be an idea to bring the data housed in your data source into the application at start as a collection. 

     

    Further information about delegation can be found here:- Canvas apps delegation overview 

  • MSM_Scoozi Profile Picture
    63 on at

    As @Ben_C said above, try bringing your data to a local collection then delegation isn't an issue.

     

    ClearCollect(LocalCollection, DB_Table_Name);

     

    Make sure if you are changing this local table that you write those entries that are changed back up to the actual DB/Table or when the app closes you could lose all changes due to them being local only. 

  • RJF61 Profile Picture
    1,265 on at

    Thanks @Ben_C and @MSM_Scoozi 

    Can you provide me some more help with the ClearCollect and population of my Drop Down field?  The information will come from a SP List "EmployeeShort".  The data is "FullName" but I also only want names where the record "JobTile" is a *Supervisor* or *Crew Chief*.  The *'s indicate wildcards in this case.

  • Ben_C Profile Picture
    on at

    Like @MSM_Scoozi said the best idea is to bring in the SharePoint data as a collection. 

     

    In the App OnStart enter the following:

     

    ClearCollect(Name of Collection, SharePoint List Name)

     

    Then if I understand your requirments correctly, in your drop down you can do the following:

     

    Filter(Name of Collection, JobRole = "Crew Chief" || JobRole: "Manager" || JobRole: "Supervisor")

     

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard