Solved: Delegation Warning

Steve0 · ‎03-26-2022

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.

dpoggemann · ‎03-26-2022

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...

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

dpoggemann · ‎03-26-2022

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...

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Steve0 · ‎03-27-2022

Any examples of how to do this? I played around with Views and Buttons over the last 24 hours and I am missing something.

rampprakash · ‎03-27-2022

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

EricRegnier · ‎03-27-2022

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-500...

"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-500...

Hope this clarifies!