Using ForAll() for large datasets can impact performance because it processes records one by one.
Alternatives such as UpdateIf(), Patch() with collections, or Power Automate flows can update records more efficiently.
Example
UpdateIf(Employees, Department="IT", {Status:"Active"})
This formula finds all employees in the IT department and updates their Status column to “Active” in a single operation.
