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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Check out the Power Apps Community Call for January 2021
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!