Power Apps Dataverse Yes/No Field [With Examples]

When building apps in Power Apps, we often need fields to store simple true/false values, such as Is Active? Is it approved? Or has Email been Sent?. In Dataverse, this type of field is called a Yes/No field.

In one of my apps, I needed a simple way to track things like whether a record was active or approved. Using a Yes/No field made everything much easier. It helps when you want to show or hide controls, check conditions in formulas, or store basic true/false choices in your tables. It’s a useful field for everyday app logic.

In this Dataverse tutorial, we’ll look at how the Dataverse Yes/No field works, how to create it, how it appears inside Power Apps, and much more:

• Display choices in a Power Apps Dropdown
• Filter the Yes/No column in the Dataverse in Power Apps
• Filter by a Specific Yes/No Value in Dataverse
• Patch the Dataverse Yes/No Column

Dataverse Yes/No column

A Dataverse Yes/No field is a basic true/false field used to store simple decisions in a table. It works like a switch; the value can only be Yes (true) or No (false). This makes it perfect for checking whether a record is active, approved, or completed, or for situations where you only need two possible answers.

For example, if a record’s “Is Active” value is Yes, you can show extra details; if it’s No, you can hide them.

Create a Yes/No Column in Dataverse Table

Next, we will see how to create a Yes/No column in the Dataverse table. Follow the instructions below:

Navigate to your Dataverse Custom data table (Job Seekers Registration List), and click on the + New column. On the New column pane, specify the following fields:

Field	Description
Display name	Provide the required Yes/No column name (example: Is Document Submitted).
Description	Give a detailed description of the field that will be created.
Data type	Click the chevron to view Choice and Yes/No options, then select Yes/No.
Behavior	Select the field behavior: either Simple, Calculated, or Rollup.
Required	Choose it as Business Recommended, Business Required, or Optional.
Searchable	Check this option to make the field searchable (enabled by default).
Choices	There are two types of choices available, i.e. Label = This label will let you change the label’s name, for example, from No to Off or something else. Value = The label value field will also have a starting value of 0, 1, 2, and so forth. Also, you can provide the color for the choices.
Default choice	Select a default value (Yes or No). The default is No.
Schema name	Expanding Advanced options shows the Schema name, which is automatically created and locked once saved.

Now, save the column as shown below. After a second, the Yes/No field is ready for use in the Dataverse table. The yes-no field is visible in the screenshot below, along with each row’s values.

This is how we can create a Yes/No Column in the Dataverse table.

Display Dataverse Yes No Choices in a Power Apps Dropdown

In the next step, we’ll learn how to show Dataverse Choice or Yes/No values in a Dropdown control.

First, add the Dataverse table to your app by going to Data -> + Add data -> Search for the table name (Job Seekers Registration Lists) and select it. Once added, all columns will be accessible in Power Apps.

Now, add a Power Apps Dropdown control and apply the code to its Items property:

Choices('Is Document Submitted (Job Seekers Registration Lists)')

Where,

1. Is Document Submitted = Name of the Yes/No field
2. Job Seekers Registration Lists = Dataverse table name

NOTE:

You can use the Power Apps Combo box control instead of the Power Apps Dropdown control.

Refer to the image below.

Save, Publish, and Preview the app. When we click the Chevron, the Yes/No choices are displayed as shown in the sample below.

This is how to display choices in a Power Apps Dropdown Control.

Filter Dataverse Yes/No Column in Power Apps

In this section, we’ll learn how to filter a Dataverse Yes/No column in Power Apps.

Let’s take a simple example. On the screen, there is a Combo box and a Data table. The Combo box displays Yes and No options from a Dataverse Choice column.

The goal is to filter the Data table based on the value selected in the Combo box. When a user chooses Yes or No, the Data table should automatically update and display only the records that match the specified value.

For instance, if Yes is selected in the Combo box, the Data table will show only the records where the value is Yes.

To achieve this, select the Combo box control and set its Items property as:

Items = Choices('Is Document Submitted (Job Seekers Registration Lists)')

1. Is Document Submitted = Dataverse Yes No Choice column name
2. Job Seekers Registration Lists = Dataverse Table name

Then, add a Power Apps Data table and apply the code below to its Items property as:

Items = Filter(
    'Job Seekers Registration Lists',
    'Is Document Submitted' = cmbIsDocSubmitted.Selected.Value
)

Where,

cmbIsDocSubmitted = This is the Combo box control name

Refer to the figure below.

Save the app and then run a preview. The data table will filter based on any choice value (Yes/No) that you choose from the combo box.

Filter by a Specific Dataverse Yes/No Value in Power Apps

There is a Gallery control in Power Apps. The next step is to filter out all records with a No value and show only the specific records.

To work around this, select the gallery control and set its Items property to the code below:

Items = Filter(
    'Job Seekers Registration Lists',
    'Is Document Submitted' = 'Is Document Submitted (Job Seekers Registration Lists)'.No
)

Where,

No = Specify the specific choice value from the Dataverse Yes No field

Patch Dataverse Yes/No Column

Next, we will see how to patch the Yes/No column in Dataverse in Power Apps.

The screenshot below shows a Job Seekers Registration Form built using multiple Power Apps input controls along with a Register button.

One of the fields is a Dropdown control named Is Document Submitted, linked to a Dataverse Yes/No column. The goal is to save this Yes/No value to the corresponding Dataverse table using Power Apps.

Users must complete all fields on the form, including the Yes/No selection, before clicking the Register button. Once the button is clicked, a new record is created in the Job Seekers Registration List Dataverse table, as shown below.

Refer to the things below to approach this.

First, select the Dropdown control (Is Document Submitted) and set its Items property as:

Items = Choices('Is Document Submitted (Job Seekers Registration Lists)')

Select the REGISTER button and apply the code below to its OnSelect property as:

OnSelect = Patch(
    'Job Seekers Registration Lists',
    Defaults('Job Seekers Registration Lists'),
    {'First Name': txtFirstName.Text},
    {SurName: txtSurName.Text},
    {RegistrationID: txtRegID.Text},
    {AddressForCorrespondence: txtAddress.Text},
    {'Is Document Submitted': ddSelectOption.Selected.Value}
)

1. txtFirstName = Text input control name for the first name.
2. txtSurName = Text input control name for the Surname.
3. txtRegID = Text input control name for the Registration ID.
4. txtAddress = Text input control name for the Address.
5. ddSelectOption = Dropdown control name

Refer to the screenshot below.

Now save, publish, and preview the app. Provide all the information in the form, then tap the REGISTER button.

Then, go back to the Dataverse table and refresh it. You can see the new item has been created in the Dataverse table as image below.

This Dataverse tutorial explains what the Yes/No field is, how to create a Yes/No column in a Dataverse table, and its uses. Also, we covered many topics below:

• Display choices in a Power Apps Dropdown
• Filter the Yes/No column Dataverse in Power Apps
• Filtering by a Specific Yes/No Value in Dataverse
• Patch Dataverse Yes/No Column

Also, you may like some more Dataverse tutorials:

• Create Dataverse File Field
• Upload Images to Dataverse From Power Apps
• Filter Power Apps Gallery By Dataverse Choice Column
• Remove Commas From Dataverse Number Field
• Get Dataverse Created by in Power Automate