Power Apps

Patch Checkbox values into SharePoint list

(0) Share

Report

Posted on by PraveenC

166

Hello All,

I have a SharePoint list page with my CheckBox values.

I have populated above values using a gallery Control.

Wrote Code on

OnCheck - Collect(colJustification,ThisItem)

OnUnCheck events - Remove(colJustification,ThisItem)

When I tried with this code

'Justification to Forego Competitive Bid Process': colJustification

Got Below error

I also tried with .Value and .Text, but thats not working either.

Here is the Column setting in SharePoint

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi PraveenC,

Here's what you should do.

1. Add the choice options you have in a separate list to the Choice column instead.

2. Populate your gallery Items with the Choices from the choice column

3. OnCheck and OnUncheck properties will remain the same

4. Add a button to the screen to save the selections in your SP List

Here's how the solution will look:

Choice Column

Gallery Items:

Choices([@SPList].choice)

OnCheck

Collect(colJustification,ThisItem)

OnUnCheck

Remove(colJustification,ThisItem)

Patch button

//Replace the LookUp with Defaults(SPList) to Patch as New items Patch( SPList, LookUp( SPList, ID = 2 ), { choice: Distinct( colJustification, Value ) } )

Final Result

If you still wish you to use a separate list for Choices, you can BUT you will need populate the Choice column with the exact values as choices.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
PraveenC 166 on at

Like (0)

Report
Copy link

Link copied!

Hello @Nandit

I have to use another Share point List and cant add the choices into a choices field directly as the length of each choice value is too long and we cant reduce their length. So I cant put the exact same values in both Share Point List and Choice column.

Was this reply helpful? Yes No