Mastering Delegation in Power Apps: A Comprehensive Guide

Thanks for explaining the horrors of delegation, Shane. Just in time as well, as I have a Power apps interview tomorrow and I JUST KNOW that the 'D' word will crop up at some point in my ordeal. Wish me luck!

Dear Shane, I love your videos so much and learned alot from ur tutorial. But til day I am still unable to resolve delegation for distinct dropdown...III...i believe this is a very serious issue for many of us using powerapps with sharepoint as datasource.

I broke one of my apps today. It made me come scrambling back to you for help. I watched this video a few times when I started using Power Apps but it's always good to get a refresh. Thanks again Shane.

I know many if not most of us are thinking the same thing: Sharepoint is free. It's capabilities are there to lure customers into the higher license tiers. I have not a doubt in my mind that Microsoft could solve the delegation issues with sharepoint lists - but it's not profitable.

Thank you so much. This video helped me a lot! : )

Hi Shane,
My name is Mike and I'm having trouble trying to find a way to solve delegation warning on my power app. I'm using sharepoint lists for my datasource.
So I have a grid calling WorkOrderDetail list that has ProductId column. I want to display on the grid sum of Qty from ReceivingDetail list where ProductId = ThisItem.ProductId.
this is my code:
Sum(Filter(ReceivingDetail, ProductId = ThisItem.ProductId), TotalReceivedQty)
but i got the delegation warning. How can I solve this problem?
Thank you
Mike

So where sharepoint can be viewed in an excel file via a query connection, is that limited in the same way?

Thank you for this Video
i have a problem with Filter Function Result
i know Delegation limitation but i use a simple Filter to get a table data as below
in text Proberty for Text Label >>> Count Row(Filter('My Data Verse Table', 'email column' = User().email))
But i get only one record Table
if i use >>> Filter('My Data Verse Table', 'email Coulon' = User().email) in item Proberty for a gallary it list all record Correctly.
Can You offer some help.
Thank You.

Date is not delegable so I can't use a date picker, I have to convert the date to an integer. But why? Having fun as my main table has over 1 million rows and the date table over 30,000 rows. And I am using SQL. Thanks for the clear collect tip I'll won't use that and see if that resolves one of my delegation issues. However not happy about having to filter on integer date.

Thanks for the video - any insights on how to deal with Delegation and the non-delegable Distinct() function ?

Setting limit to 1 is a really nice trick. Thanks!

Oh my god, that was great, thank you!

Lol I wish I had more teachers like you !!

I was told that distinct with nested filter delegates 50k records, Is that true

Hey shane! Great video! If i were to move to use SQL to house my data, is there licensing issues if internal users want to use my powerapp? Will they need premium licensing as well?

It's irresponsible on the part of MS to make an issue of delegation. Putting users in a bind of either messing with delegation or spending big bucks on premium sources like Dataverse is a vendor created problem. People like Shane need to start calling MS out on this.

Master class again. top!

Learned few good tips to test delegation. Thank You, Shawn.

Thank you Shane Young for the refresher on delegation

Good video on explaining delegation. Definitely a video a lot of people can benefit from. Thanks

When i change my delegation limit to 2 for testing purposes, all of my Dropdowns that normally just use an unfilitered sharepoint list as datasource get cut after the second entry. Is this really a delegation limit or is that a different powerplatform problem? Because in the dropdowns there should be nothing to delegate?

Excellent vid, Shane. Appreciate it.

Fantastic video (as ever!), Shane. Such an important topic for many of us who are using SharePoint as a data source. Thank you!

where is the link to the video with the workaround for the delegation limit?

Shane, cheers again, such an important video. I went back through your related vids and a Q occurred to me that has never been clarified (perhaps because the answer is obvious but we are all told “there are no stupid questions” so….): Most of the time users want more recent records. Does delegation always work on 1st x records based on ID index from 1st to last, OR…..if the E.g. Sharepoint list is sorted ‘newest to oldest’ , would delegation work on the most recent items?

I would LOVE to see an affordable expansion of Dataverse capacity. Dataverse could be so amazing if I could just store more in it. I need the best of both SQL and SharePoint. Dataverse would be it except I keep hitting capacity limits...

is that an artificial limitation? I expected Sharepoint to be able to do odata API. It has search… Weird to call it delegation when it’s an api call basically

Thanks!

I guess a good point to take away from this video is also not to use SharePoint as a data source

I build my apps with a delegation limit of 1 to be 100% sure I am not being limited by delegation.

This is great video but We want video about Power Apps with Sql End to End Project that helps lot

A big thank for your amazing tip to place the non delegation limit to 1 in order to not fall into Power Apps lying in our faces!
Deal with delegation is not easy and has to be considered and done at the beginning of the app making, a good reminder ;)

Great video and content. Always good to refresh ones memory about this important topic. Thanks for sharing

Knowing that you are a SharePoint guru I'm sure you also know that behind SharePoint list is .... an SQL database. So we don't need to wonder why we have these delegation issues. We know it is intentionally caused by our friends at microsoft. I just need to figure out why we should move away from their SharePoint to another microsoft product. But I guess it all comes down to licencing costs allowing them to make a little more money.

Hi Shane, thank you for your awesome content! A question about performance. I have an 'Inventory Transaction' table, in which the amount of rows will be huge. in the same table, I have incoming (one row) and outgoing (can be several rows). All the outgoing rows are related to one incoming row. Meaning, I can calculate the current saldo of the incoming row, by a filter and sum function of incoming and outgoing rows.

I have two options. To add one 'Current Saldo' column, that always have the calculated sum up to date.
Or I can always use the filter and sum function to calculate the current saldo.

What is your thoughts on performance in this case. I would prefer to always use the filter and sum function. But since the inventory table will be huge, and, many times I will need to perform the sum filter calculation for roughly 100 rows, affecting perhaps 100 rows each, meaning 10 000 rows in total.

I would be really thankful for your thoughts in this case!

I hate to say it but the technical reason SharePoint doesn't delegate where it probably should is most likely to make people pay for dataverse

Really well explained, I finally understand delegation 😂

2000 - meh!

THX for a very good recap. Cannot wait to start on your Power Platform University

Shane - great video (as always).
I have question to gallery behavior shown in your video (but not fully) - you mentioned gallery connected to large list can load all items (when you will scroll) - you reached 6000 items (no error on your side). I did some more tests with list that contained +10 000 items, results:
every time I reach more than 5000 items: 5300 / 5500 / 1 time I reached 8000 items I receive following error in Network tab
Status: 400, "The attempted operation is prohibited because it exceeds the list view threshold." Scroll does not work anymore.
My Gallery's Data Source is super simple: just 'Large List' (no filtering, no nothing fancy) Gallery inside just displays single title.
I believe it is connected with SP List limitations and ID field not being Indexed :-( (OOTB SharePoint online uses this ID to do paging / via RenderListDataAsStream API requests)
Any comments from your side (how to bypass this limit - to have infinite scroll possibility ??)

But when does the SharePoint list threshold limit of 5000 hits the Power Apps? When the gallery is showing 10000 items, its definitely overcoming the threshold limit. Or did I miss anything here?

How to merge Screen or two apps into one in power apps ? I have two different apps.

Thank you !!!

Off topic but it looks like Microsoft fixed that weird separator in galleries.

Excellent explanation.

Awesome video !

If I understand right, If I use Dataverse with 100000 entries , the search, filter, whatever, PowerApps will find and show me all record I want, even if there filter/find 20000 entries ?

The fact that AddColumns isn't delegable but there is no warning is a very nasty feature. Tip, set the delegation limit to one or three rows to check your application for these invisible delegation warnings. Edit: shane explains this! Very good tip.

As always, great job in explaining the concepts and use of the Power Platform! The only thing missing from your recent videos is the "Intro"... What's up with dropping it?

A great refresher... thanks Shane 💥💥