Notifications
Announcements
Hello Community,
Toggle submits to SharePoint "true" or "false".
Need to be converted to "1" or "0" for calculating in SharePoint.
Any assistance would be greatly appreciated.
V/R
chudson002
Hi @chudson002 ,
I assume you are wanting to write the value to a numeric field in SharePoint? Put the toggle (I will call it Toggle1 below) in the card belonging to this field (you will have to unlock it) and only two changes needed. The Default of the toggle is
Parent.Default=1
The Update of the Data Card is
If( Toggle1.Value, 1, 0 )
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.
Warren, toggle is in a gallery and patching to SharePoint.
Any thoughts?
@chudson002
Toggles are either true or false. You can use @WarrenBelz 's simple formula to convert the value of the toggle to 1/0, "Yes"/"No", as binary numbers or text to save in your SharePoint list.
I got it...Thanks for the nudge.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268