Unanswered

Patch Checkbox Value in a Gallery to a SharePoint with a YES/NO data type column

(0) Share

Report

Posted on by JanCarla

Hi All,

I would like to ask for help how to patch the checkbox values in a Gallery to a SharePoint with a YES/NO data type column.

Categories:

Building Power Apps

Sample_1.png

I have the same question (0)

All responses (8)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @JanCarla ,

You simply patch the Value of the checkbox

Patch( ListName, LookUp( . . . . .), {YesNoColumnName: CheckboxName.Value} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
JanCarla 23 on at

Like (0)

Report

Is your answer applicable to checkboxes inside a gallery? If yes, could you please elaborate how. Thank you.

Was this reply helpful? Yes No
JanCarla 23 on at

Like (0)

Report

Is your answer applicable to checkboxes inside a gallery? If yes, could you please elaborate how. Thank you.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@JanCarla ,

Yes as long as you patching the current record from inside the gallery.

Was this reply helpful? Yes No
JanCarla 23 on at

Like (0)

Report

But all checkboxes return true in my SPO List although I did not check them all.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@JanCarla ,
If you patch the checkbox Value, it will patch false if the box is unchecked - you did not mention multiple boxes - what is the code you are using (in Text please)

Was this reply helpful? Yes No
JanCarla 23 on at

Like (0)

Report

Sorry, but I am still new to power apps. I don't know where to start when patching multiple checkboxes in a gallery. Would you be kind to share how to do it?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
@JanCarla ,

OK - it is better to patch them one at a time, but you would use something like (for updating existing records)

Patch( SPListName, ForAll( GalleryName.AllItems As aPAtch, { ID: aPatch.ID, YesNoField: aPatch.CheckboxName.Value } ) )

For new records, just leave out the ID line.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No