cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Penguniii
Frequent Visitor

Can I use Toggle to update the list in sharepoint with Yes/No column

I'm having a Gallary like this now

Penguniii_0-1660116197019.png

With the "Toggle" is used for isActive yes/no column. Is there any way to update the value in sharepoint column whenever I switch off/no that Toggle? 

Thank you for your help!

1 ACCEPTED SOLUTION

Accepted Solutions
earribasb
Regular Visitor

Yes, you can take advance of the OnChange property of the toggle and the PATCH function to update the SharePoint item:


 

Patch(List,LookUp(List,ID=ThisItem.ID),{ShP_Toggle_Column:Toggle1.Value})

View solution in original post

4 REPLIES 4
earribasb
Regular Visitor

Yes, you can take advance of the OnChange property of the toggle and the PATCH function to update the SharePoint item:


 

Patch(List,LookUp(List,ID=ThisItem.ID),{ShP_Toggle_Column:Toggle1.Value})

Hi earribasb 

I don't know why but it just automatically switches to the default value and there is no update on the sharepoint list. And here my properties

Penguniii_0-1660118757333.png

Penguniii_1-1660118803803.png

Do I need to change something?

Thanks for replying ❤️

Kimii
Resolver II
Resolver II

hi @Penguniii  

your toggle [Onchange] might be:

Patch(List, {ID: ThisItem.ID}, {Active: Self.Value})

 

Regards,

 

 

Penguniii
Frequent Visitor

It's working! Thank you so much @Kimii  and @earribasb for all of your time and help. Cheers

 

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 (2,206)