PATCH A SharePoint Choices Column With Multiple Values In Power Apps



Goal

Change the ColorsChoice column (Choices Type) from blank to the values “Blue”, “White” and “Red”


Input

Painting Jobs (SharePoint List)

IDAddressJobDateColorsChoice
130 State Street11/1/2020


Patch Function Code
Patch(
    'Painting Jobs',
    LookUp('Painting Jobs', ID=1),
    {
        ColorsChoice: [
            {Value: "Red"},
            {Value: "White"},
            {Value: "Blue"}
        ]
    }
)


Output

Painting Jobs (SharePoint List)

IDItemAmountStatus
1Steak Dinner52.50Red
White
Blue




Scenario #1: ComboBox

Patch a value found in a combo box to a Choices field.



Patch Function Code
Patch(
    'Painting Jobs',
    LookUp('Painting Jobs', ID=1),
    {
        ColorsChoice: ComboBox_Colors.SelectedItems
    }
)