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.
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.
Deleting the Text formula worked for me.
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
Really, this is acceptable to need to create an If statement with unicode characters? To me it's a bug.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
190 | |
53 | |
51 | |
36 | |
33 |
User | Count |
---|---|
268 | |
96 | |
80 | |
68 | |
68 |