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"}
}
)
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
}
)
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
}
)
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
}
)
Did You Enjoy This Article? 😺
Subscribe to get new Power Apps articles sent to your inbox each week for FREE