Power Fx function
Change data
Top 12 most-used
Patch
Creates or edits data source records.
What it does
Creates or edits data source records.
The job: Behavior functions that create, edit, or delete records — they run on events like a button OnSelect.
Try this
Adapt this formula from the nextM365 reference hub:
Patch(Tasks, Defaults(Tasks), {Title: "New"})How to use Patch
Start from the task, not the alphabet. If you are shaping rows for a gallery, reach for Patch alongside the other data functions in its group; if you are saving, navigating, or changing state, use it on an event such as a button OnSelect rather than in a display property. When a formula misbehaves, check for a blank value where you expected text, then confirm the behaviour against the examples in the Power Fx function reference hub.
New to the language itself? Read What Is Microsoft Power Fx? first, then come back here when you need this specific tool.