Announcements
Can someone help me write this query to my Dataverse to clear the delegation error? This query worked fine when we used it against an Excel sheet but now throws delegation errors with dataverse.
Hi @Steve0 ,
A couple of thoughts here:
1. Sometimes I have been able to get rid of the delegation warning by setting the myProfile value to a variable, just something to try.
2. Another option here is to create a view that limits to your user (i.e. "My Leaves") that is restricted by the logged in user, you could put much of the same filter code in the view definition vs. doing in the Canvas app...
Any examples of how to do this? I played around with Views and Buttons over the last 24 hours and I am missing something.
Hello @Steve0
Can you please give a try below for below one.
On Start - Set a variable as
Set(userprofile,userprofile.UserPrincipalName)
And replace your filter query with userprofile
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hi @Steve0,
This warning is as-design and will not prevent your query from "working". It's a warning to alert you that delegation might occur and might have the wrong results because you're using a large set of data. Suggest to have a quick read thorugh this MS doc:: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview?WT.mc_id=DX-MVP-5004271#delegable-data-sources
"Delegation is where the expressiveness of Power Apps formulas meets the need to minimize data moving over the network. In short, Power Apps will delegate the processing of data to the data source, rather than moving the data to the app for processing locally."
If you know your data will never exceed 2000 records then you can change the limit to 2000 (it's the max): https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview?WT.mc_id=DX-MVP-5004271#changing-the-limit
Hope this clarifies!
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.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
