web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Creating on Sharepoint...

Power Apps

Answered

Creating on Sharepoint List item from multiple values in powerapps

(0) Share

Report

Report

Posted on by andrewp3283

27

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 Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LuizVicente 984 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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

Join the conversation