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 the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights