Announcements
Hi,
I'm really confused about a delegation issue I'm running into on one of my formulas. My datasource is Dataverse. My formula is below:Sort(Filter('HPC Data', 'Sales Representative' = User().Email), 'HCP Name Address', Ascending)According to Microsoft's documentation, both Sort and Filter are delegable. If I remove the Sort function the problem still remains. If anyone could give some guidance I will greatly appreciate it!Thanks!
@alandilworth
With({wUser: User().Email},
Sort(Filter('HPC Data', 'Sales Representative' = wUser), 'HCP Name Address', Ascending)
)
Thanks for the suggestion Alex. Unfortunately it is still not working. One thing I noticed is if I use the same function in a blank app I do not encounter this problem. I'm not sure what could be interacting with this in my production app since it is just a dropdown with this my formula in the items category. It does not interact with anything else
did testing on my end and cannot replicate the warning with Dataverse.
may be you have a hidden control that is placed over or behind your dropdown and that control shows that warning?
I kind of explained it wrong. It's not actually showing a warning. I'm testing for delegation issues where there are no warnings by setting the data row limit where delegation is not supported to 1
i think now i understand.
by limiting to 1 you get only 1 record back even if there are more? and you want to see if that case happens?
CountRows(Sort(Filter('HPC Data', 'Sales Representative' = User().Email), 'HCP Name Address', Ascending))
CountRows will return the correct number of records that should be returned when unlimited.
so building a condition comparing that number with the number of actual rows may help
It did return the correct number of rows, but I have another update. On my blank app with nothing but a dropdown with my function populating the items category, it started encountering the same problem after closing and reopening the app. I've been playing around with it and it will work for a while then stop
So I found the problem. It ended up being a dropdown/combobox issue. When I placed the same function in a gallery I no longer had the delegation issue. Very odd
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 638
Haque 317
WarrenBelz 315 Most Valuable Professional
