cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Steve0
Microsoft
Microsoft

Delegation Warning

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.

Delegation warning.pngDelegation.png

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

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

4 REPLIES 4
dpoggemann
Super User
Super User

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

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
Super User
Super User

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
Super User
Super User

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!

 

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,688)