cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcBailey
Resolver II
Resolver II

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
Memorable Member
Memorable Member

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

3 REPLIES 3
Sienna
Memorable Member
Memorable Member

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

Anonymous
Not applicable

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

 

 

Same problem, is there a solution ?

 

Thanks !

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (46,597)