2023-02-15
Quick tip! Boolean in SQL
Are you looking for a boolean column in SQL? Or have a virtual table and need a toggle/checkbox in your app?
If you have just a string/text field with True/False this wont work.
You need to convert the column in SQL to BIT.
Bit is an integer data type that can take a value of 0, 1, or NULL
1 for true, 0 for false.
Then reload/refresh your table into your dataverse/virtual table and it can be selected with a checkbox!
Nathalie - 14:42:16 @ Power Apps, Canvas App, Model Driven App, New functionality, Virtual Tables, Dataverse | Add a comment
Last 5 entries
- The secret to doing Microsoft exams for free!
- Quick tip! Using QuickChart.IO with dynamic values (Canvas app edition)
- Setting restrictive security on a Word Template while leaving sections open (Restrictive editing)
- Business Process Flow - How to automate moving through different stages
- How to repeat words in Microsoft Word (XML Mappings)