Announcements
Hi
Toggle data will be stored in database as true or false
But I am looking for data to be stored as Yes/ No form so that I want to show my data in gallery in the form of Yes/no not as true or false
As you can see in my gallery I want it to be Yes/No
Please help
In your label's text property you can below formula - If(ThisItem.ToggleColumnName = true, "Yes", "No")
Thank You @NandiniBhagya20 It perfectly worked now I am able to get Yes/No
it would be better for me to know that, is there any way that I can store value as yes/no at the backend data source
If it is for display purpose you can use column formatting or you can add a calculated column in your list with below formula - IF([YesNoColumn]=true, "Yes","No")But i will not suggest this, you can go for column formatting -
{"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json","elmType": "div","txtContent": "=if(@currentField==true, 'Yes', 'No')"}https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
Okay, Your solution worked perfectly with SharePoint data source but it is not working with OneDrive data source
can you please suggest me
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 846
Valantis 532
Haque 410
