I have a SQL view with a bit (Boolean) column. The column is called 'Description Edited'.
If I add a Data Table to my app and connect to this view, the data card for this column defaults to a checkbox. The data card has a Text property which defaults to ThisItem.'Description Edited'
In the data table, all the check boxes are checked despite the value in the database.
Now, if I deliberately make an error in the formula for that Text property, it works!
What's up with that?
Solved! Go to Solution.
@VijayTailorI removed and re-added the column from the data table and it's turned it into a text field. I think this is good enough.
Hi @WillPage ,
You have to set the Default Property for CheckBox Like below.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Same result @VijayTailor but it's not delegable.
I might just update the view to make string column instead of boolean and be done with this. It's clearly a bug in Power Apps.
@VijayTailor I didn't add the checkbox in the data table, it was automatic when I added the boolean column to the table via the "Edit fields" button.
No choice to change it in the data card properties.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.