Announcements
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.
Is there way to eliminate this issue?
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
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.
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 248 Super User 2026 Season 2
WarrenBelz 192 Most Valuable Professional
Mohsin Ali 135