CRM Crate

Enhanced Delegation for Microsoft Dataverse in Power Apps

We will learn and understand the usage of Enhanced Delegation for Microsoft Dataverse in Power Apps. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Apps.

Enhanced Delegation for Microsoft Dataverse in Power Apps

What is delegation in Power Apps?

Delegation” is where the expressiveness of Canvas Apps formulas suffice the need to minimize data moving over the network. As a app customizer / developer, the delegation is a very important concept to understand, especially if you are working with large sets of data in PowerApps. For example, when performing data operations like searching and filtering for specific records the delegation offloads the work to the data source. In simple words, it means that the operations like Filter, Lookup, and Search are performed at the data source instead of bringing the¬†complete set of data to the application and then processing it locally.

Understanding Enhanced Delegation for Microsoft Dataverse

  • Microsoft has provided a way to make more functions as delegable in Power Apps / Canvas App while working with Microsoft Dataverse as a source.
  • The below given functions are not delegable and restricted the data access to up-to first 2000 rows (based on the app settings).
  1. in
  2. AsType
  3. CountRows
  4. CountIf
  • We can now make the above given functions as delegable with help of the “Enhanced Delegation for Microsoft Dataverse”. Enabling this feature will leverage these functions to use an entire dataset directly without any delegation limits (Maximum 2000 rows).
  • To enable the enhanced delegation, open the Canvas App in Power App Studio (https://make.powerapps.com/), click on Settings, navigate to Upcoming Features and enable the Enhanced Delegation as shown below.
Enhanced Delegation for Microsoft Dataverse
  • The below animation demonstrates the usage of Enhanced Delegation for Dataverse.

Thus, we learned to use Enhanced Delegation for Microsoft Dataverse in Power Apps.

5 1 vote
Article Rating
Subscribe
Notify of

0 Comments
Inline Feedbacks
View all comments
error: CRM Crate Security Engine - Disabled Right Click & Selection!

Congratulations!

Well Done,
Welcome to CRM Crate

Stay tuned with us and get all latest updates and learning in Microsoft CRM and related techonologes.