Power Apps SharePoint task list

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 CodePatch[ '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 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 } ]

Video liên quan

Chủ Đề