PATCH A SharePoint Task Outcome Column In Power Apps



Goal

Change the StatusTaskOutcome column (Choices Type) from blank to “Approved” in a SharePoint List


Input

Travel Expenses (SharePoint List)

IDItemAmountStatusTaskOutcome
1Steak Dinner52.50


Patch Function Code
Patch(
    'Travel Expenses',
    LookUp('Travel Expenses', ID=1),
    {
        StatusTaskOutcome: {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 task outcome 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 task outcome 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 task outcome field.



Patch Function Code
Patch(
    'Travel Expenses',
    LookUp('Travel Expenses', ID=1),
    {
        Status: Radio_Status.Selected.Value
    }
)