PATCH A SharePoint Choices Column In Power Apps
PATCH A SharePoint Choices Column In Power Apps Goal Change the StatusChoice column (Choices Type) from “Submitted” to “Approved” in a SharePoint List Input ...
- Published
- Reading time
- 1 min read
Before you start
Is this guide for you?
- Best entry point
- SharePoint
- Time investment
- 1 min read
Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-choices-column/. Author: Matthew Devaney.
PATCH A SharePoint Choices Column In Power Apps Goal
Change the StatusChoice column (Choices Type) from “Submitted” to “Approved” in a SharePoint List Input Travel Expenses (SharePoint List) ID Item Amount StatusChoice 1 Steak Dinner 52.50 Submitted Patch Function Code Patch(
'Travel Expenses' , LookUp( 'Travel Expenses' , ID= 1 ), {
StatusChoice : { Value : "Approved" } } ) Code language: JavaScript ( javascript ) Output Travel Expenses (SharePoint List) ID Item Amount Status 1 Steak Dinner 52.50 Approved Scenario #1: Combo Box
Patch a value found in a combo box to a Choices field. Patch Function Code Patch(
'Travel Expenses' , LookUp( 'Travel Expenses' , ID= 1 ), { Status : Combobox_Status.Selected } ) Code language: JavaScript ( javascript ) Scenario #2: Dropdown
Patch a value found in a dropdown to a Choices field. Patch Function Code Patch(
'Travel Expenses' , LookUp( 'Travel Expenses' , ID= 1 ), { Status : Dropdown_Status.Selected } ) Code language: JavaScript ( javascript ) Scenario #3: Dropdown
Patch a value found in radio buttons to a Choices field. Patch Function Code Patch(
'Travel Expenses' , LookUp( 'Travel Expenses' , ID= 1 ), {
Status : Radio_Status.Selected.Value } ) Code language: JavaScript ( javascript ) Did You Enjoy This Article? 😺
Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up
Tagged
Patch · SharePoint
Have a Microsoft 365 topic idea?
Share article suggestions, community session ideas, corrections, or real-world scenarios for future nextM365 learning notes.
Keep learning Microsoft 365
Explore more practical guides for SharePoint, Power Platform, Copilot Studio, migration, automation, governance, and security.
Continue learning
Related tutorials
Related questions
Related comparisons
Next action