Unanswered

Power Automate OData filter expression for Yes/No Column

(2) Share

Report

Posted on by BillyBreathes

I have a yes/no column named AlertActive and I want my "Get Items" action to filter only those records where the AlertActive column is equal to "True." With SharePoint, we would just use:
AlertActive eq '1' but Dataverse doesn't like that. I have found the Schema name for the column, and I have tried the following:
eq true

eq True

eq '1'

eq '0'

but I get an error that states:
A binary operator with incompatible types was detected. Found operand types 'Edm.Boolean' and 'Edm.Int32' for operator kind 'Equal'.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (1)

All responses (4)

Answers (1)

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (2)

Report

eq 0
eq 1

these are also valid

eq false

eq true

I know you write that "eq true" did not work but maybe the field is not a Yes/No and is a Choice instead? if is a Choice the numeric values (without the quotes as I wrote) work

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (2)

Report

When writing filter expressions in power automate I like to use @GuidoPreite ‘s Dataverse Rest Builder. You can install it on your environment and then use it to get the Power Automate expression exactly formatted to work.
Like stated by Guido - eq 1 without the single quotes should do the trick. DRB will let you know immediately if otherwise.

Was this reply helpful? Yes No
Verified answer

AllanDeCastro 412 Most Valuable Professional on at

Like (4)

Report
Hello @BillyBreathes

In Dataverse, filtering Boolean fields in the "Get Items" action requires the correct syntax to be used. The Boolean field should be compared against the proper Boolean values, true or false. Unlike SharePoint, Dataverse expects these values to be without quotes and strictly in lowercase.
Here's the correct way to filter the AlertActive column in Dataverse using OData syntax:
Use eq true for records where AlertActive is True.
Use eq false for records where AlertActive is False.
Assuming the logical name of your AlertActive column is alertactive, the OData filter query should look like this:

alertactive eq true

1 people found this reply helpful.

Was this reply helpful? Yes No
BillyBreathes 73 on at

Like (1)

Report

I get the following error:

A binary operator with incompatible types was detected. Found operand types 'Edm.Boolean' and 'Edm.Int32' for operator kind 'Equal'.

Was this reply helpful? Yes No