Power Fx function
Patch (bulk) — Power Fx function reference
Update many records at once.
Syntax
powerfx
Patch( DataSource, Table( ChangeRecord1, ChangeRecord2, ... ) )
Examples
powerfx
Patch(Tasks, colEdits)
→ All updated
powerfx
Patch(Tasks, ForAll(colEdits, {ID: ThisRecord.ID, Status: "Archived"}))powerfx
Patch(Tasks, Filter(colEdits, IsDirty), colEdits)
Common mistakes & gotchas
- Prefer Patch over SubmitForm when you control the payload — fewer surprises, better performance.
- Bulk Patch still issues one request per row against tabular connectors under the hood — it batches the syntax, not the network calls.
- Every record needs its primary key populated or Power Apps creates new rows instead of updating the intended ones.
Related Power Fx functions
From Creating & changing records