Creating on Sharepoint List item from multiple values in powerapps

[andrewp3283]

I have multiple checkboxes with my application and the user can select which activity they require, what I need to do is then store those selection of either Yes or No on one record on the sharepoint list for example:

Selections:

Activity1

Activity2

Activity3

If Activity 1 and 3 are selected then the list item should be

Activity1 = YES

Activity2 = NO

Activity3 = YES

I cannot figure out the process for doing this, have been looking at some kind of collection and then sending that to the SP List but cant get all the values into one collection.

[Roverandom · Accepted solution]

What is the data type of the column in the SharePoint list?

You can create a Record variable like this:

Set(
    gblRecordActivities,
    {
        Activity1: Checkbox1.Value,
        Activity2: Checkbox2.Value,
        Activity3: Checkbox3.Value
        // and so on
    }
)

To Patch in SharePoint (assuming the column is text):

Patch(
    SPList,
    Defaults(SPList),
    {
        Column1: gblRecordActivities.Activity1,
        Column2: gblRecordActivities.Activity2
        //...
    }
)

[andrewp3283]

Excellent thanks for that - I was stuck in a loop and could not see another option to get around it 🙂