In this #PowerShot, I will show you how you can make more functions as delegable in Canvas Apps while working with Microsoft Dataverse as a data source.
Let's Get Started
We will take a look at the functions that are now delegable as per the latest release. The list of these functions include:
1. CountRows
2. CountIf
3. First
4. in
Previously, these functions were not delegable and restricted the data access to upto first 2000 rows (based on the app settings) and now they can be used on the entire dataset directly. To benefit from this capability, you will have to enable it in the Advanced Settings of the app. For newly created apps, this feature is enabled by default. You can follow the below steps to check the feature status:
1. Click on File.
2. Select Settings and then Advanced Settings
3. Scroll and Search for Enhanced delegation for Common Data Service.
Setup Example
In this post, we looked at a few more functions that are now delegable in Power Apps when using Canvas Apps with Microsoft Dataverse. These capabilities are important for enhancing app performance and can significantly improve the load time of data when working with Microsoft Dataverse as a data source.
I hope you found this interesting and it helped you. Thank you for reading!