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...
Solved! Go to Solution.
OnCheck: Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “Yes”})
OnUncheck: Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “No”})
Default: If(ThisItem.ColumnNameLinkedToCeckBox="Yes",true,false)
OnCheck: Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “Yes”})
OnUncheck: Patch(YorDatabaseName, GalleryName.Selected, {Attendent: “No”})
Default: If(ThisItem.ColumnNameLinkedToCeckBox="Yes",true,false)
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
Same problem, is there a solution ?
Thanks !
User | Count |
---|---|
184 | |
123 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
132 | |
85 | |
78 |