Power Fx function
Patch (create) — Power Fx function reference
Create a new record.
Syntax
powerfx
Patch( DataSource, Defaults( DataSource ), ChangeRecord )
Examples
powerfx
Patch(Tasks, Defaults(Tasks), {Title: txtTitle.Text})→ New record
powerfx
Patch(Tasks, Defaults(Tasks), {Title: txtTitle.Text, DueDate: DatePicker1.SelectedDate, Status: "Open"})powerfx
Set(varNewOrder, Patch(Orders, Defaults(Orders), {Customer: cmbCustomer.Selected, Amount: Value(txtAmount.Text)}))Common mistakes & gotchas
- Call Defaults(DataSource) fresh for each new record — a variable captured earlier can carry stale defaults (e.g. a CreatedBy that no longer matches the current user).
- Dataverse enforces required columns at write time; SharePoint is more forgiving and will happily accept a partial record.
Related Power Fx functions
From Creating & changing records