With Power Automate we can create Flows that beat the delegation limit and in this video we show exactly that! If you are just looking for the secret sauce just go right to the @15:50 mark and that's where we make the Flow!
This is part 5 of our complete app creation:
Part 1: https://youtu.be/xw-ZXrjTY4Q
Part 2: https://youtu.be/EilrB5RqJDc
Part 3: https://youtu.be/EVAwMmc9qos
Part 4: https://youtu.be/xgrEL1VX-zc
Part 5: https://youtu.be/sVJPqC6h5-o
Using Power Automate as a workaround to the delegation limits in Power Apps can be highly effective, especially for larger datasets. By creating flows in Power Automate that handle data operations—like advanced queries or aggregations—on SharePoint lists or other data sources, you can bypass the Power Apps delegation constraints. These flows can then be triggered directly from Power Apps, allowing the retrieval, processing, and return of data in manageable chunks or as a pre-processed result, ensuring your app remains responsive and robust, regardless of dataset size. This method not only overcomes delegation limits but also enhances the app's capability by leveraging the power of server-side processing.
When integrating SharePoint with Power Apps, users often encounter the "delegation" issue, which arises when dealing with datasets larger than 500 items by default or 2000 max. Power Apps requires this delegation to efficiently handle data queries without overloading memory or processing power. To manage this, it's crucial to use delegable queries and functions in Power Apps, such as filtering on indexed columns, to ensure your app remains performant and scalable. Understanding and planning for these delegation limits is key to building effective and efficient applications that leverage SharePoint data.
Chapters:
0:00 Introduction
0:49 Populate Fake Data with Power Apps
4:15 Populate Fake Data with Power Automate
11:00 Creating a Search Bar with StartsWith
14:00 Breaking with Non-Delegable Functions
15:50 The Flow to Fix Delegation
19:50 The Fx Formula that uses Flow for Delegation
26:40 Testing
27:35 Our Patch Broke Due to using a Collection
28:30 Adding the Power Automate Fx to Patch on Edit