Notifications
Announcements
Hi,
I have a datatable connect to DB table. this table has two columns, which is 1 or 0. I have choose checkbox to show this boolean value in the datatable. but the checkbox has been checked no matter the value is 1 or 0.
Please advise how to make the checkbox is checked only for the 1 value.
Thanks,
Xiang
see screenshot:
@Xiangchen_2019
A checkbox is appearing because your Data Table is using the font Open Sans. Try something different like Segoe UI or Arial and the values will display properly.
---Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."
@mdevaney
Thank you. I have tried, but the checkbox still has been showed as checked. I want to show the checkbox, but I want to the checkbox got checked once is '1' and unchecked once it is '0'.
the screensht is as below:
Do any of the available fonts show something different than a checkbox for you?
@mdevaney,
I have tried all the other font, all shows the checkbox as checked.
@RezaDorrani
Hi there Reza. It appears you are online at this moment so I hope you don't mind me asking a question.
@Xiangchen_2019 has a true/false field showing as a checkbox no matter what value true/false. Is this something you have encountered before? Changing fonts seems to work for me but it doesn't appear to be the solution for them.
Hi @mdevaney & @Xiangchen_2019
I am not sure how checkbox is showing as an option in the first place
Just tested with a bit type column in the DB and these are the only options a DataTable in PowerApps provides me afor this type of column
I have tried all fonts as well - but mine stays consistent as toggle and also shows accurate data
--------------------------------------------------------------------------------If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
@RezaDorrani and @mdevaney
My bit type column shows as ""boolean column" in data table. see screenshot. I do not have toggle column as option at all.
Try this: change the control type to a Text Column using the Edit Fields menu
Then, select the confirmed column and put this code in the Text property. Do the same for the registered column. It worked for me!
If(ThisItem.PerDiem,"☑","☐")
I think manually defining the outputs using a Unicode symbol will work here. However, I did not think of that approach until you showed us the idea to change the control type idea. Thank you for taking the time during your evening to help us out. I very much appreciate it!
It works for me. Thank you so much!
Thank you so much for all your time and efforts.
I came across the same issue @Xiangchen_2019 & @mdevaney . Every checkbox in the datatable was checked even when it should have been unchecked. I played with the functions and still didn't like the results. Then I accidentally deleted the Text field for the column and the checkboxes are filled accurately now.
So to get the checkboxes in the column to react correctly to a boolean value just remove the Text value for the column.
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 793 Most Valuable Professional
Michael E. Gernaey 333 Super User 2025 Season 2
Power Platform 1919 268
