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)

IDItemAmountStatusChoice
1Steak Dinner52.50Submitted


Patch Function Code
Patch(
    'Travel Expenses',
    LookUp('Travel Expenses', ID=1),
    {
        StatusChoice: {Value: "Approved"}
    }
)


Output

Travel Expenses (SharePoint List)

IDItemAmountStatus
1Steak Dinner52.50Approved




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
    }
)