Cheat sheet
Patch SharePoint Columns Cheat Sheet
Quick examples for patching text, choice, person, lookup, date, yes/no, and metadata columns from Power Apps.
Patch SharePoint columnsPower Apps person fieldPower Apps choice field
Who this helps
Makers who know the field they need to save and want the correct Patch shape quickly.
What to standardize
- Person fields need claims-shaped records.
- Choice fields need records with Value.
- Lookup fields need Id and Value.
- Dates should be validated before save.
Examples
Choice field
Patch a SharePoint choice column from a combo box.
Formula / code
Patch(Requests, galRequests.Selected, { Priority: { Value: cmbPriority.Selected.Value } })Expected result: Priority stores the selected choice value.
Common mistakes
- Patching only text when SharePoint expects a choice record
Lookup field
Patch a lookup column from a selected record.
Formula / code
Patch(Requests, galRequests.Selected, { Customer: { Id: cmbCustomer.Selected.ID, Value: cmbCustomer.Selected.Title } })Expected result: The lookup points to the selected customer item.
Common mistakes
- Using ID instead of Id
- Omitting the display value