Business Value
Customers can ensure greater accuracy and save time with Power Fx functions. They can use UpdateIf
and RemoveIf
on up to 2,000 records in large data sets. This change reduces the strict delegation limit that only worked on the first 2,000 cached records. Now, the functions work on the whole data source and stop only when they reach 2,000 records that match the If
condition.
Feature Details
Authors don't need to take any action to turn on this feature. The feature is on by default for all new apps. This feature update enhances the UpdateIf
and RemoveIf
functions in Power Fx. With this feature, these functions can operate on more records than basic nondelegable actions allow. Without this feature, these functions work locally and limit evaluation to the first 2,000 records that the data source retrieves. For example, if only three records in the first set of 2,000 records meet the If
condition, UpdateIf
and RemoveIf
functions operate on only those three records.
With this feature, these functions work locally and don't delegate to the server. However, they simulate delegation by bringing down and evaluating the If
condition for records beyond the initial 2,000 limit. This feature prepares and runs the update or remove actions for the Update
or Remove
functions on up to 2,000 records at a time.
This implementation can update any set of records in a large dataset but stays limited to 2,000 records it changes at a time. If Power Apps caches a large amount of data, the UpdateIf
and RemoveIf
functions can work on more than 2,000 records. Use this feature safely if you know the set of records that meet the If
condition is less than the 2,000 limit.
Users can turn on this feature for old apps or turn it off in Settings > New section.
Enabled for:
Users by admins, makers, or analysts