PATCH A SharePoint Task Outcome Column In Power Apps
Goal
Change the StatusTaskOutcome column [Choices Type] from blank to Approved in a SharePoint List
Travel Expenses [SharePoint List]
ID | Item | Amount | StatusTaskOutcome |
1 | Steak Dinner | 52.50 |
Patch Function CodePatch[ 'Travel Expenses', LookUp['Travel Expenses', ID=1], { StatusTaskOutcome: {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 acombo box to a task outcome field.
Patch Function CodePatch[ 'Travel Expenses', LookUp['Travel Expenses', ID=1], { Status: Combobox_Status.Selected } ]
Scenario #2: Dropdown
Patch a value found in adropdown to a task outcome field.
Patch Function CodePatch[ 'Travel Expenses', LookUp['Travel Expenses', ID=1], { Status: Dropdown_Status.Selected } ]
Scenario #3: Dropdown
Patch a value found inradio buttons to a task outcome field.
Patch Function CodePatch[ 'Travel Expenses', LookUp['Travel Expenses', ID=1], { Status: Radio_Status.Selected.Value } ]