Answered

Creating on Sharepoint List item from multiple values in powerapps

(0) Share

Report

Posted on by 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.

All responses (2)

Answers (1)

andrewp3283 27 on at

Like (0)

Report

Re: Creating on Sharepoint List item from multiple values in powerapps

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

LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report
Re: Creating on Sharepoint List item from multiple values in powerapps

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 //... } )