cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcBailey
Level 8

Checkbox Value needs to Patch or UpdateIf to SharePoint List

Originally - I thought this was going to be an easy one but I am still struggling with it.

 

I need some help on the approach and code for this.

 

I have a Gallery that has a Checkbox bound to each record.  I need to update my SharePoint List named ProjectSourceMatch with the value of the Checkbox using either Patch or UpdateIf.  I have tried using the OnCheck,OnUncheck, and OnSelect functions for the Checkbox with update code unsuccessfully.  I have also tried using a TextInput OnChange with code with Default set to: If(Checkbox3.Value=true,1,2) thinking that when the value changed it would trigger the OnChange function but it does not unless there is a manual entry into the TextInput (which is not an option).  I have attached an image of my test model.

 

Any help would be greatly appreciated - Thanks, Marc...

 

Checkbox Issue.png

1 ACCEPTED SOLUTION

Accepted Solutions
Sienna
Level 10

Re: Checkbox Value needs to Patch or UpdateIf to SharePoint List

OnCheck:      Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “Yes”})

OnUncheck:  Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “No”})

Default:         If(ThisItem.ColumnNameLinkedToCeckBox="Yes",true,false)

View solution in original post

2 REPLIES 2
Sienna
Level 10

Re: Checkbox Value needs to Patch or UpdateIf to SharePoint List

OnCheck:      Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “Yes”})

OnUncheck:  Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “No”})

Default:         If(ThisItem.ColumnNameLinkedToCeckBox="Yes",true,false)

View solution in original post

Highlighted
Mikkola
Level: Powered On

Re: Checkbox Value needs to Patch or UpdateIf to SharePoint List

Hey, this got me halfway. 

i have oncheck onuncheck and default setting like this and it works when i check the box.

But when i uncheck the box it displays  the right data change and uncheks the box for a few second, but returns to checked and also patches the data to "Yes" again.

any ideas would be appreciated.

 

Details:

Onedrive excel file

Using gallery and Toggle(Is there a difference using this and normal checkbox?)

Toggle: 

Oncheck: Patch(Attendees;ThisItem;{Arrival:"Yes"})

Onuncheck: Patch(Attendees;ThisItem;{Arrival:"No"})

Default: If(ThisItem.Arrival="Yes";true;false)

 

So everything works until u accidentaly check someone and want to uncheck Smiley Tongue

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 154 members 3,171 guests
Please welcome our newest community members: