Mastering Delegation in Power Apps: A Comprehensive Guide
Вставка
- Опубліковано 20 лип 2024
- #powerapps #PowerPlatform #CanvasApps
Up your Power Apps Skills Today!
Link: www.powerapps911.com/up-your-...
In this in-depth tutorial, we dive deep into the concept of delegation in Power Apps, a crucial aspect that every Power Apps developer needs to understand for building efficient and high-performing applications.
Learn how delegation works with different data sources like SharePoint and Dataverse and understand the difference between "delegable" and "non-delegable" queries. This video provides a hands-on demonstration of connecting a Power App to a SharePoint list, adding a gallery to display data, and how Power Apps retrieves data on an as-needed basis, enhancing performance when dealing with large data sets.
We also explore the "data row limit" setting in Power Apps, which determines the number of records Power Apps retrieves for non-delegable queries. Discover how some queries that are non-delegable in SharePoint become delegable in Dataverse, and how this impacts the functionality and performance of your app.
This video is a must-watch for anyone looking to master Power Apps, whether you're a beginner just starting out or an experienced developer looking to brush up on your skills. By understanding delegation, you'll be able to build more efficient, responsive applications, ensuring a smooth user experience even when dealing with large data sets.
We also discuss common pitfalls and misconceptions about delegation in Power Apps, providing you with the knowledge to avoid potential issues in your app development process.
Don't forget to like, share, and subscribe for more tutorials on mastering Power Apps. For further resources and in-depth training classes, check out the links in the description below. Happy app building!
Need some help on something you are working on, contact us!
Link: www.powerapps911.com/contact
0:00 Start
0:35 Adding a large SharePoint List and Gallery
1:58 Gallery AllItemsCount and scrolling
3:35 Filter with Delegation working
4:55 Search fucntion and no Delegation
7:17 Changing the Delegation limit and the 2000 item limit
9:12 Comparing SharePoint and Dataverse delegation
11:30 Power Apps Delegation Documentation Overview
14:37 SharePoint ID doesn't work
15:45 Be weary
16:40 Set Data Row Limit to 1 to troubleshoot
18:01 Protect your users and common problems
20:33 Collections are not Delegable
PowerApps911
Link: www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane - Наука та технологія
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!
How did it go?🎉
Happy to help. How did it go?
@@ShanesCows funny story -- I got the day wrong! It's actually tomorrow 12:00 GMT. Wish me luck...again!
@@davidgreen6486 Hope it went well!
also have an interview tomorrow also I feel very attacked for using collections.
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 ;)
😎 Comments like this make me smile. Thank you 😊
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.
Glad it helped! Always panic when you break something that was working. 🙃
Learned few good tips to test delegation. Thank You, Shawn.
Glad it was helpful!
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!
Thank you Shane Young for the refresher on delegation
You are welcome
Great video and content. Always good to refresh ones memory about this important topic. Thanks for sharing
Happy to help. Have a great day. 🐶
Good video on explaining delegation. Definitely a video a lot of people can benefit from. Thanks
You bet!
THX for a very good recap. Cannot wait to start on your Power Platform University
Looking forward to having you Frank. 😎
Setting limit to 1 is a really nice trick. Thanks!
You're welcome!
Oh my god, that was great, thank you!
A great refresher... thanks Shane 💥💥
Happy to help. Have a great day. 🐶
Thank you so much. This video helped me a lot! : )
You're very welcome!
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.
Master class again. top!
Thank you! Cheers!
I guess a good point to take away from this video is also not to use SharePoint as a data source
It has its challenges for sure but most apps are built on it.
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.
Great minds think alike 😎
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?
You can nest queries. So put your delegable sort inside of a non-delegable query to get what you want. 🤩 This video talks about it. ua-cam.com/video/lYi24okXDPs/v-deo.html
Excellent explanation.
Thanks 😊
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?
Been trying different formats to get to the content faster. I also miss “here’s our intro@ 😍
@@ShanesCows i like 'These guys!' lol
Hey Shane, thanks for all the material you share. Quick question. I know that collections are non delegable. However, I am wondering if they are partially delegable. For example, ClearCollect(collectionName,Filter(datasource,dropdown.Selected.Id = Id)). Is the filter portion of the equation delegable?
Yes. This video will help on partial delegation like you are thinking about ua-cam.com/video/iG8SjWtX1yM/v-deo.html
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...
I am hopeful overtime we continue to see economies of scale and lower pricing. I agree with your thoughts.
Thanks for the video - any insights on how to deal with Delegation and the non-delegable Distinct() function ?
Distinct not being delegable isn't something I have a work around for. Best I can offer is trying to shrink your data set first with nested fucntions. ua-cam.com/video/iG8SjWtX1yM/v-deo.html
Thanks!
Thank you for the support. 😎
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 ??)
Unfortunately, pagination in Power Apps is very inconsistent, and it rarely even works properly.
What it does most of the time is to download an increasing amount of data each time. In other words, it gets 100 items, then 200 items, and so on. Rather than just the next 100 items. Actually, it's worse than that.
The effect, of course, is that a request of more than 5000 items will be reached, and the limit threshold error will inevitably occur.
@ShanesCows can you please take a look on above and share your thoughts on this
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
Excellent vid, Shane. Appreciate it.
Happy to help
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 ?
Yup. 😎 I have never scrolled past 8700 entries but in theory it could keep goin.
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
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?
Yes, SQL is a premium datasource so all users of the app internal or external would need a premium license
I build my apps with a delegation limit of 1 to be 100% sure I am not being limited by delegation.
Approved! 🤩
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.
Really well explained, I finally understand delegation 😂
Awesome!
This is great video but We want video about Power Apps with Sql End to End Project that helps lot
Noted. Thanks.
Lol I wish I had more teachers like you !!
Thanks. 😎
How to merge Screen or two apps into one in power apps ? I have two different apps.
Thank you !!!
You can copy and paste between apps in studio. Open Both and copy and paste is no problem
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?
Interesting. I never realized this. I wonder if it changed. 🫤 But you are correct, the Delegation limit effect dropdowns even for delegable queries. 😔
So where sharepoint can be viewed in an excel file via a query connection, is that limited in the same way?
I am not sure, I have never looked into how Excel does it. SOrry.
Thank you Shane ❤️🔥❤️🔥❤️🔥
Glad to help. 😀
where is the link to the video with the workaround for the delegation limit?
This one. ua-cam.com/video/lYi24okXDPs/v-deo.html
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?
What do you mean Sharepoint List limit being 5000? I thought you can have like 50k-500k rows in a Sharepoint List?
@@finnpower92 you can have 30 million items in SharePoint list. But there is a threshold limit of 5000 per list view. Just checking with Shane if there is an impact on PowerApps due to that threshold limit
The 5000 item limit in SharePoint is around filtering views. If you index the column in SharePoint you can stretch to 25k items last time I checked. 😎
Thank you!
I was told that distinct with nested filter delegates 50k records, Is that true
Distinct is not delegable as far as I know. Unless they added it for DataVerse
@ShanesCows Thanks Shane, apprwcite the reply. Do you know if countrows with nested filters can return 50k rows from sharepoint?
I just finished to understand clearly u could mix for the worst a Filter delegable function with an In operator making all ur formula undelegable with text.
Happened to me so many time til i saw a former video from u using Startswith function to avoid the In operator.
U r so didactic ! Thx u again for ur work & ur video !!!
Awesome. Glad it helped.
Woot! First!
High five. 🙌
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.
Off topic but it looks like Microsoft fixed that weird separator in galleries.
when? i still had it today - i mean, they did fix its positioning though. its just that its white and the background is white.
@@caraziegel7652 the position thing was very annoying.
I still had problems with it last week so I am hopeful you are right. 😎
@@ShanesCows I added a gallery to an app yesterday and it wasn’t giving me a problem. Hopefully it wasn’t a fluke.
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.
David I think the would say it is technical limitations of SharePoint as a data source but not sure. Sorry, don't shoot the messenger. :)
Hey Shane. There is a work around provided here: ua-cam.com/video/QNSRKpyIHPg/v-deo.html. Is that something you would suggest to overcome the 2000 limit or not? Could it cause performance issues? Thnx for the help anyway!!
It works but it scares me that you are creating stability issues. I feel like Microsoft limited things to 2000 for a reason so I never go over it. But it is possible for sure. :)
First to like
Good job!
2000 - meh!
No one loves that number.
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
Because Sum is not delegable with your data souce, you can't. :( But let me ask you this? How many records does your Filter formula return? If it is less than the delegation limit, then you will be fine. You can learn more about how nested delegable and non-delegable queries behave here. ua-cam.com/video/iG8SjWtX1yM/v-deo.html