Power Apps has introduced new delegation features to reduce issues arising from non-delegated Power Fx query expressions. Previously, a query that could not be run on a data source's server would pull the first 500/2000 unfiltered records, possibly leading to inaccuracies and performance issues.
With the update, Power Fx expressions requiring asynchronous evaluation will now be delegated, preventing the need to separate them into different formulas. Also, several functions that used to interrupt delegation will now be evaluated on the client side and within a delegated expression. These include GUID, IsToday, Now, Rand, RandBetween, and Today, rolling out between June 12th and 26th.
Furthermore, the experimental preview of UpdateIf has been announced, which extends the delegation range and enables full delegation to the back-end data source when supported. This feature, along with RemoveIf, will roll out in all commercial regions by June 21. These updates identify individual records and send the update/removes to the server, optimizing Power Apps operations.
While this can be super helpful at times, it can lead to wrong results.
- Delegation improvements for better app performance and correctness
- Reduced formula authoring confusion
- Power Fx query expressions made easier
- Double blue underline to indicate non-delegated expressions
- Fetches first 500/2000 unfiltered records when delegation is not possible
- Potential for incorrect results due to non-delegated expressions
Secondly, the list of functions listed below will no longer break delegation. They will be evaluated on the client and evaluated for a delegated expression.
Improving the Power Apps Delegation Experience
These updates will bring numerous benefits to Power Apps users, such as better app performance and formula authoring. Users should expect more accurate results when creating Power Fx query expressions, as delegation will now be more efficient and user-friendly. The changes are designed to enhance the overall experience and usability of Power Apps, making it a more powerful tool for app development.
Read the full article Delegation improvements Async, UpdateIf, and miscellaneous functions
Learn about Delegation improvements Async, UpdateIf, and miscellaneous functions
This month, Microsoft is rolling out several improvements to delegation that should improve app performance, correctness, and reduce confusion when authoring formulas. When authoring a Power Fx query expression, such as a Filter, this will be indicated with a double blue underline. If the expression cannot be delegated to the data source's server, Power Apps will fetch the first 500/2000 unfiltered records and finish the query operation with the data it can retrieve. This can lead to wrong results.
The delegation improvements will help to ensure that the query expression is delegated to the data source server and the results returned will be more accurate. In addition, Async functions have been improved to help reduce the resource usage and latency of the app. Finally, the UpdateIf and miscellaneous functions have also been improved to further enhance accuracy and reduce confusion.
These delegation improvements should help to improve the performance, accuracy, and resource usage of Power Apps, making it easier for users to create accurate and efficient formulas. With the improved delegation capabilities, Power Apps will be able to provide more accurate results and reduce formula authoring confusion.
More links on about Delegation improvements Async, UpdateIf, and miscellaneous functions
- Power Apps archivos
- Top 10 Power Apps Functions You Should Know (With Examples): One of the key ... Delegation improvements Async, UpdateIf, and miscellaneous functions ...
- Chirag Patel #M365UK (@techChirag) / Twitter
- 14 hours ago — Delegation improvements – Async, UpdateIf, and miscellaneous functions. We are excited to announce that several key delegation improvements will roll out ...
- Power Apps Guide - Resources
- Delegation improvements Async, UpdateIf, and miscellaneous functions · Announcing General Availability of wrap for Power Apps wizard · May 2023 updates for ...
- Arpit Power Guide – a guide to powering up community
- 21 hours ago — Find out what's new in Microsoft Dynamics 365 applications and Microsoft Power Platform. Delegation improvements Async, UpdateIf, and miscellaneous functions.
- Microsoft Dynamics 365 & Power Platform | Study Learn ...
- Delegation improvements – Async, UpdateIf, and miscellaneous functions ... New Microsoft Power Automate features to develop and orchestrate automation.
- Microsoft Power Apps training & resources
- Latest news from the Power Apps blog · Delegation improvements Async, UpdateIf, and miscellaneous functions · Announcing General Availability of wrap for Power ...
Delegation, Async, UpdateIf, Miscellaneous functions, Formula Authoring, Power Fx query