Power Fx function
UpdateIf — Power Fx function reference
Change fields on matching records.
Syntax
powerfx
UpdateIf( DataSource, Condition1, ChangeRecord1 [, Condition2, ChangeRecord2, ... ] )
Examples
powerfx
UpdateIf(Tasks, Priority = "Low", {Status: "Closed"})→ Matches changed
powerfx
UpdateIf(Tasks, Priority = "Low" && DueDate < Today(), {Status: "Closed"})powerfx
UpdateIf(colCart, Item = "Pen", {Qty: Qty + 1})Common mistakes & gotchas
- Multiple condition/change pairs are evaluated independently, not as an if/elseif chain — a row matching two conditions gets both changes applied.
- Same delegation caveat as Filter/RemoveIf: a non-delegable condition on a large tabular source only updates the rows within the retrieved page.
Related Power Fx functions
From Creating & changing records