DELEGATION in Power Apps | Must Know to build efficient Apps
Вставка
- Опубліковано 23 лип 2024
- In this Power Apps tutorial video, we will dive deep into the KEY concept of DELEGATION in Power Apps that every App developer needs to understand for building efficient and performant applications. Working with large data sets requires using data sources and formulas that can be delegated and hence it's important to understand differences between delegable and non-delegable queries against different data sources. Key is to write Power Apps formulas that support delegation against delegable data sources like SharePoint, Dataverse, SQL.
We will learn how delegation works to minimize the amount of data that must be brought to your device. Delegation is where Power Apps will delegate the processing of data to the data source, rather than moving the data to the app for processing it locally.
We will explore how a Gallery loads data from a large data source in batches when delegable queries are performed (optimized loading of data), understand the network calls in play using Monitor, learn about PowerApps "data row limit" (500 - 2000 data row limit), learn how to write delegable formulas to work with large data sets, learn how collections, variables etc. work when delegation is in play, learn how certain formulas may not display a delegation warning and much more..
This video is a must-watch for anyone looking to deep dive into Power Apps DELEGATION - A key concept that every Power App Maker, whether a beginner or an expert, must be aware of.
#PowerApps #PowerPlatform #canvasapps
🔗 Understand delegation in a canvas app
learn.microsoft.com/en-us/pow...
🔗 Learn more about Power Apps Delegation and ways to overcome delegation
• Power Apps Delegation ...
Table of Contents:
00:00 - Introduction to delegation in Power Apps
00:30 - What is delegation?
01:19 - Delegation in action with large data source (SharePoint List)
02:15 - Gallery optimized loading of data
03:35 - Which data sources and queries support Delegation?
04:35 - Data row limit for Non-delegable query
06:52 - How to identify delegation warnings in your Power App?
07:42 - Write delegable queries in Power Apps
09:26 - Hidden delegation challenges - Watch out
10:45 - Partial delegation with Collections and Variables
12:34 - Must Know about delegation - Наука та технологія
Yet another awesome video Reza. Thank you so much!
You’re most welcome
The advice to stich together collections to load large data sets is probably the most shared (bad) advice in the community. Thank you for making such an excellent video that highlights this.
I couldn't agree more. What surprises me is that folks are using those techniques to avoid delegation.
@@RezaDorrani I think it is because delegation is sometimes explained as the maximum number of rows PowerApps is able to work with, which is not true at all!
A better explanation would be: It is the maximum number of rows it SHOULD work with, but LOCALLY and not server side.
The example where you scrolled to the second page of your dataset showed this so beautifully together with the row count. It showed that when you respect delegation, PowerApps will actually help you paginate your dataset and ensure you still get the correct result from your queries. I mean how nice is that?! You don't even have to do anything; Power Apps just handles it for you.
I stitched together collections in the beginning because I read bad advice and the worst thing about it, is that it kinda works; it performs badly, but it gets the job done.
It was only later until I learned about delegation from gurus like you and Shane, that I understood my approach was severely flawed, and that by understanding delegation I realized that it makes my life much easier.
I simply didn't understand that PowerApps could filter 1.000.000 rows server side trough delegable queries, but still be limited to only show 500/2000 rows locally. But it makes sense when you think about as you said, that the whole system is in place to urge you to minimize the amount of traffic between the app and the server.
I still have many apps where the delegation is set to 2000 rows, but when you think about, how often do you really need to present more than 500 records to the user at the same time? Probably never. And how many apps have tables with more than 500 records? Probably all of them.
Delegation works brilliantly when you understand it, and that's why I wanted to show my appreciation for your work Reza, because your video can improve the whole Power Apps community in a place where it is most needed.
That testing tip for setting return query to "1" row was awesome!
👍
A really good refresher course on this all important topic. Hopefully, a few more functions will become delegable soon. Thanks for sharing. Appreciated.
Glad it was helpful!
Great Video as usual. Thanks for the Info
Thank you @Reza, for another excellent and informative video . Tons of thanks. 👍
Great video as usual, very informative!
Thanks for this great overview of Delegation!
Most welcome
Thank you for a refresher!!!
Welcome!!!
Well explained and to the point. Thanks
You're most welcome!
informative and well explained with example...
Thanks
Dude you are amazing. I learn best from examples like you show. Thank you so much.
The Superbowl is on right now and I'm learning from your video. I'm learning here to
advance my personal power, otherwise I would be wasting time. Thanks :)
BTW what version are your currently using?
Thanks so much!
Enjoy the super bowl.
version of?
Well explained Reza. This really helps.
Glad to hear that
Thank you another amazing video, Reza
My pleasure!
Amazing tips as always ❤❤ Thanks Reza
Glad you like them!
Thank you for this useful reminder
Always welcome
Great video as always! I saw in documentation the 'in' Fonction is delegable in dataverse but I try to filter a gallery on a multi choices column and get delegation warning. Does a workaround exists? I try addcolumn(concat to filter on string but performance is not great because the app needs to collect the whole table.
in is delegable for certain data types not all. Check documentation.
It's been great Reza sir if you post on your experienced basis,scenario based interview questions its been really helpful for us
You are Gem 💎💎 for us
Regards
That is not an area I am well aware of.
Awesome video Reza. In regards to collection, one of my client keeps insisting that we load 6k to 8k into a collection and I have to use concurrent function. Takes about 30 secs and the app's performance is slightly worse, not App breaking but not as nice at all.
Loading > 2k records is not advisable. Performance will take a hit.
Thanks!
Welcome!
if the function is non delegable then the intellisense should be showing the delegation warning,..... surprised to know the issue with ' with ' function ... thanks for this amazing video sir............
I agree that the warning must be shown. I will take that feedback to the team.
"With" not having a warning is expected in the example shown at ~10:40, it would be the same as if you did
1) ClearCollect(colStudentData, Students),
2) Filter(colStudentData, Region.Value "South") (no delegation)
@@MuFeR. I agree. Delegation warnings should only be for functions that is expected to work in the data source. With is a purely Power Apps function that can not be delegated. So a warning is misleading.
Very well explained Reza sir! Thanks for creating this video. I have seen Power Apps slowing down with 1000 rows in SP list. What is the best or recommended source/backend for any Power App?
Thanks!
There is no single answer to best data source. Answer is "it depends". I deep dived into this concept during the LIVE training workshops.
@@RezaDorrani Okay..thanks
Good morning Reza,
I have a sharepoint table with 2 columns, the first: ID_PARENT is numeric and the second PROJECT is a text and contains 8500 records.
If I use the Filter(StartsWith(PROJECT,"PROJECT001")) function I get all the records of PROJECT001, if instead I use the Filter(StartsWith(ID_PARENT, 10)) function I get only the data that are in the first 2000 records. Maybe the problem is that you can't use StartsWith with numeric fields? Thank you.
you can't use StartsWith with numeric fields
@@RezaDorrani Thank you.
VITAL! Thanks Reza!
Most welcome!
Hello Reza, It's again a nice video. I have question regarding delegation. I set delegation limit to 2000 (that is max limit) in this case if my search result crosses the limit i would get only 2000 records, how do i get rest data which couildn't come beacuase of limit.
Welcome!
Thats the limitation if your query is not delegable. Better not to use search function and use StartsWith in that scenario.
Hi Reza,
Thanks for this video. Really Helpful. Quick Question:
I am working with around 0.5 Million rows SQL table. On this table we need to perform a group by operation and create landing page and for slicers we need to perform a distinct on column and get all different values from that column. The challenge here now is Group by & Distinct are non delegable Power Fx functions when connected to a SQL connector. There is no way that I can found to do this with other delegable functions.
How do we approach this problem now?
Create sql views
Table shaping functions are not delegable.
Sql views may be an option
@@adarshmc8158 @RezaDorrani - Thanks for the idea, I can create a sql view for group by post which also I will end up with a table greater than 2000 rows, On this table if I am using distinct its still an issue as it picks up the values from only first 2000 rows and I end up not having all unique values from my column. Anny idea on how do I tackle this after creating Views. Thanks in Advance
1) Don't trust the warnings for delegation (either that they do or don't show as delegable)
2) Delegation ONLY becomes an issue for your apps if the dataset gets large (>500 or >2000 once you change the defaults).
3) You can test to see if you have some delegation issues by setting an abnormally low query limit for your app (down from 500 to a smaller #)
4) All Delegation issues can be solved through better queries, better data organization, using Power Automate & ParseJSON, etc. (which all mean Dataverse isn't required to solve delegation issues in most scenarios)
5) Microsoft is likely to push better delegation features within Dataverse first (but that doesn't mean you should use Dataverse unless your app requires it or your organization is focused on supporting Dataverse more widely)
Thanks for sharing
1:13 Very Good
Great videos! Do you know how to turn the Comments off when using the Edit mode in PowerApps?
I am not aware as I have not come across anyone wanting to turn it off. Check documentation and see if there is something provided for it.
So it’s not a good idea to load sharpoint data in collections and use collections as data source? Should we connect to SharePoint data source directly if your records are more than 2k?
Collection is not a data source. It is only a space to temporarily load data for the users session. Best to connect directly to data sources.
Hey Reza, can you pleaseeee let me know how to get the attachments through ms forms. Setting is disabled for external users, but i need it anyhow to put the documents as attachments in the saem list item created by form submitted. Please Help!!!
I have done videos on it.
Ms forms anonymous users - there is no option for attachments.
If setting is disabled - there is no other option that Im aware of.
Thanks for swift reply. But can you pleasee let me know any other options but ms forms to get the responses as well as attachments from external organisations into our sharepoint.
@@dhavalbendale5509 Im not aware of other options.
Thanks for this great video. Very Helpful!! May we use Power Automate to bring more than 2000 items to Power Apps and keep them into a collection? Using Get Items action?
Welcome!
Delegation over anything. Why do you need to load 2000 records in collection via flow?
To avoid the delegation issue. I understand we should not work with large local collections but, sometimes, it can help when you need to use non delegable queries as CountRows or Distinct and the number of records are, e.g., between 1 and 10000 (no more).
@@user-bo4qe9ww5n I would not recommend doing that as it will have performance implications. Thats why one has to use better data sources like Dataverse that offers max flexibility in terms of delegation and more.
I have a SQL (Synapse) datasource with about 60,000 records. What's the best way to work with this?
I have no clue about that
Hi Reza, If I want to make an app that can connect Dataverse and Web Apps, Can we make a connection between them?
Whats web apps?
Power apps can connect to multiple data sources.
@@RezaDorrani Can we input data from a web (HTML, CSS, JavaScript) to a dataverse?
@@annisamegarestya8800 Not that I am aware of
I have a really large list with about 90K records. Filter and StartsWith does not show any records. I don't see any delegation warning but no results either. To be precise, it is very errant in showing results. Sometimes I see results and sometimes I don't even when I know there are records that start with the term provided.
Depends upon the query you have framed. I have not come across any issues with lists > 500k records as well. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
CAN we show more than 2k line items in gallery, gallery is delegable or not
Thats what the video explains. If query is delegable and you keep scrolling down, gallery will keep loading all the data.
@@RezaDorrani i mean can it load after 2k line items..it would be good if you shown that in video
@@malikhan0123 Try it out and see. It will load as many as you need.
I dont see any user doing that though as scrolling to get data to find is not ideal. Better to have good filters on screen.
How to upload multiple files to dataverse record and save it to share point doc library.And send notification email to user in that particular dataverse record with multiple documents attached in the email
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, can you please help me to load more than 6000 records in powerapps
If you keep scrolling in gallery it will load as many as you need
how to handle countrows function under a filter query?
like:
CountRows(Filter(datasource,logic)) > 10
Countrows is not a delegate function unless you use dataverse (limits are documented)
@@RezaDorrani On a text propert of a label, I write " CountRows(Filter(Temp_Item_Selection, Dealer_Code = "Cust0001")) " this code.
And it shows delegation warning.
Warning massage : The highlighted part of this formula might not work correctly on large data sets. The “CountRows” operation is not supported by this connector.
We use sql server as connector
@@RezaDorrani I write a query like " CountRows(Filter(TestDB,VendId = "Vend001")) " on a text property of a label.
But i found this warning massage.
The highlighted part of this formula might not work correctly on large data sets. The “CountRows” operation is not supported by this connector.
We use sql server as connector
@@NimbusBI CountRows is not delegable with sql either. Check documentation to see what’s supported for delegation for your data source.
😢😢😢😢😢
Good or bad?
V। ❤❤❤❤❤😂😂
?
Ko
?