🍪 Cookie Preferences

We use cookies to improve your experience and analyze site usage. You can choose which types of cookies to accept:

Help us understand how visitors interact with our website by collecting anonymous information.

Used to make advertising messages more relevant to you and your interests.

You can change your preferences anytime by clicking on the cookie settings icon in the bottom right corner.

🍪
Logo Power Platform Tips & Tricks
  • Home
  • About
  • Posts
  • Tags
  • Glossary
  • Speaking
  • Videos
  • Dark Theme
    Light Theme Dark Theme System Theme
Logo Inverted Logo
  • Tags
  • Adaptive Cards
  • Blogging
  • Boolean
  • BPF
  • Canvas App
  • Canvasapps
  • Command Bar
  • Conditions
  • Copilot Studio
  • Custom Emails
  • Data Operations
  • Dataverse
  • Dynamics365
  • Dynamics365CI
  • Expressions
  • Generative Answers
  • Github
  • Images
  • Imposter Syndrome
  • Javascript
  • Microsoft Exams
  • Microsoft Teams
  • MicrosoftTeams
  • Model Driven App
  • MPPC23
  • MSWord
  • Muppets
  • Power Automate
  • Power BI
  • Power FX
  • Power Pages
  • PowerApps
  • PowerAutomate
  • PowerBI
  • Powershell
  • QuickChartIO
  • RegEx
  • Security
  • SharePoint
  • SharePoint HTTP Series
  • Speaking
  • SQL
  • Variables
  • Virtual Tables
  • Vouchers
  • XMLMappings
Hero Image
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!

  • SQL
  • Boolean
Wednesday, February 15, 2023 | 1 minute Read
Hero Image
Dataverse Choices to SQL backend- Update!

  • SQL
  • Virtual Tables
Tuesday, February 14, 2023 | 3 minutes Read
Navigation
  • About
  • Tags
  • Glossary
  • Speaking
  • Videos
Contact me:
  • Bluesky: nathleenders.bsky.social
  • info@nathalieleenders.com
  • Nathalie-Leenders
  • Nathalie Leenders

Toha Theme Logo Toha
© 2025 Copyright Nathalie Leenders. All Rights Reserved.
Powered by Hugo Logo