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:
Solved! Go to Solution.
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!
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."
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?
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.
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.
Xiang
User | Count |
---|---|
125 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
216 | |
181 | |
140 | |
97 | |
83 |