Unanswered

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

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

Was this reply helpful? Yes No
andrewp3283 27 on at

Like (0)

Report

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

Was this reply helpful? Yes No