cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WebPortal
Post Prodigy
Post Prodigy

Toggle in gallery updating all records by default

Hello,

 

My Gallery has a Toggle input control with the following properties:

 

Default:

ThisItem.Adjudicado

 

OnCheck:

Patch(MySPList, LookUp(MySPList, MySPList_ID = ThisItem.MySPList_ID), {Adjudicado: true})

 

So, when the user changes the toggle to "On", ALL the records are updated in the Sharepoint list to True.

And, when the user changes the toggle to "Off", ALL the toggles in the Gallery go back to "On" and all the records are updated in the Sharepoint list to True.

 

The data source is a Sharepoint list and the column is a "Yes/No" field.

 

Can anyone help?

 

OnUncheck:

Patch(MySPList, LookUp(MySPList, MySPList_ID = ThisItem.MySPList_ID), {Adjudicado: false})

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @WebPortal ,

That is pretty much what I posted, but I compacted it a bit more.

A even neater option would be to get rid of the OnCheck and OnUncheck and put this OnSelect

Patch(
   MySPList,  
   {ID:ThisItem.ID}, 
   {Adjudicado: 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.

 

View solution in original post

3 REPLIES 3
WebPortal
Post Prodigy
Post Prodigy

I've found the answer here.

However, still don't understand what the OnCheck, OnUncheck are supposed to do.

WarrenBelz
Super User
Super User

Hi @WebPortal ,

I am not sure that MySPList_ID is, but this generally works

Patch(
   MySPList,  
   {ID:ThisItem.ID}, 
   {Adjudicado: true}
)

 

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.

Hi @WebPortal ,

That is pretty much what I posted, but I compacted it a bit more.

A even neater option would be to get rid of the OnCheck and OnUncheck and put this OnSelect

Patch(
   MySPList,  
   {ID:ThisItem.ID}, 
   {Adjudicado: 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.

 

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,878)