Power Fx function
Update — Power Fx function reference
Replace a record wholesale.
Syntax
powerfx
Update( DataSource, OldRecord, NewRecord )
Examples
powerfx
Update(Tasks, oldRec, newRec)
→ Record replaced
powerfx
Update(Tasks, LookUp(Tasks, ID = 5), {ID: 5, Title: "Renamed", Status: "Open", DueDate: Today()})powerfx
Update(colCart, First(colCart), {Item: "Pen", Qty: 3})Common mistakes & gotchas
- Update replaces the whole record — columns left out of NewRecord can revert to blank/default on sources that support full-record writes, unlike Patch which only touches specified columns.
- Because a full replacement record is required, Update is mostly used with collections; Patch is the usual choice for SharePoint/Dataverse/SQL.
Related Power Fx functions
From Creating & changing records