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.
Solved! Go to Solution.
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.
Yes, @JamesThurber is 100% correct. Select the column with the boolean values (where all checkboxes are shown as selected), then remove the formula within the text property of this column (mine was ThisItem.XY),
Then you achieve also displaying empty checkboxes.
(Maybe seen from a logical standpoint, the datatable only checks if there is a value, which is with regards to boolean always the case (true/false or yes/no are values vs. NULL, which is not a value).)
So after removing the formula it works as intended.
I just stumbled into this same problem. Select the column, and on the Text property you probably have a residual: ThisItem.'Has attachments'. This will trigger the checkbox to be selected all the time, no matter the font. Simple delete all the contents of the Text property, and the checkbox will work correctly
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.