web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Checkbox in a gallery

Power Apps

Answered

Checkbox in a gallery

(0) Share

Report

Report

Posted on by Kambro

80

Hi all,

I have a gallery that has a checkbox on each row. This will serve to mark if the row is approved or unapproved.

I am struggling with getting the value of the checkbox to update the underlying sharepoint list.

I have tried:

OnCheck property:

Patch(colNewExpenses,
ThisItem,
{APPROVALSTATUS:ApprovalCheckbox.Value}
)

ApprovalCheckBox is a Yes/No column in the sharepointlist.

An error is thrown that this formula has side effects and cannot be evaluated. Any suggestions to what might be causing this error?

I've also tried:

Patch(colNewExpenses,
Gallery3.Selected,
{APPROVALSTATUS:ApprovalCheckbox.Value}
)

No error is thrown but when the box is checked it does not update the sharepoint list.

Any ideas

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,319 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kambro ,

Is colNewExpenses a collection or your SharePoint list ? If you want to Patch the value of a Check Box to a Boolean (yes/no) column in a SharePoint list, OnSelect of the Check Box

Patch( SPListName, ThisItem, {APPROVALSTATUS: Self.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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kambro 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WarrenBelz

Thanks for the quick reply.

I tried adding the formula to the OnSelect property as suggested but it still has the same error "...formula has side effects...". I updated the formula to patch to my sharepoint list.

colNewExpenses is actually a collection.

Cheers
K

Was this reply helpful? Yes No
Kambro 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Wait - it actually is working now!

In the formula bar it still says that the formula has side effects, but it is pushing the update to my sharepoint list. Maybe its having undesired effects somewhere else but that is a problem for another time!

Fantastic

Was this reply helpful? Yes No

Join the conversation