Answered

Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

(0) Share

Report

Posted on by JonClay

Hi everyone,

I'm very new to Power Automate (so please forgive me!) and I'm having a problem filtering on a Boolean value. I've looked around various forums and have tried many different syntax for the filter (e.g. sic_deceased eq '1', sic deceased eq 1, sic_deceased eq "1" etc), but nothing seems to work for me.

What I'm initially trying to do is filter down where sic_deceased is TRUE (the field is either TRUE or FALSE in Dynamics), so that I can then list these rows. When I try the filter as shown below I get the following error:

Exception parsing sic_deceased eq '1' submitted for attribute filterexpression of callback registration. Target entity: contact. Exception: Microsoft.OData.ODataException: A binary operator with incompatible types was detected. Found operand types 'Edm.Boolean' and 'Edm.String' for operator kind 'Equal'.
at Microsoft.OData.UriParser.BinaryOperatorBinder.PromoteOperandTypes(BinaryOperatorKind binaryOperatorKind, SingleValueNode& left, SingleValueNode& right, TypeFacetsPromotionRules facetsPromotionRules)

Any help would be much appreciated.

Many thanks,
Jon

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,867 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @jonclaylondon,

This is a two options set type of field, correct? Like the error message says that field would be of type Edm.Boolean. Have you tried using a boolean type value like true or false?

Try the below syntax?

sic_deceased eq true

For reference a different thread about the same subject: https://powerusers.microsoft.com/t5/Building-Flows/Filter-query-on-quot-Two-options-quot-field-not-working/m-p/759413/highlight/true#M104823

Was this reply helpful? Yes No
JonClay on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus

Thank you so much - that has worked. The syntax that you gave to me must have been the only one that I hadn't tried before!

Best wishes
Jon

Was this reply helpful? Yes No
Chriddle 8,697 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
odata filters in Sharepoint are weird 🙄

Try

sic_deceased eq 1

Was this reply helpful? Yes No
Expiscornovus 33,867 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Chriddle,

This was Dataverse, not SharePoint 😉

Was this reply helpful? Yes No
Chriddle 8,697 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

😳

Was this reply helpful? Yes No
Chriddle 8,697 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
At least it was obvious from my post, that I missundertood something 🤣

Shouln't just

sic_deceased

be sufficient if its value is boolean?

Was this reply helpful? Yes No
Expiscornovus 33,867 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Chriddle,

We get a lot of questions about the OData Filter queries in SharePoint, to be fair. Easy mistake to make, has happened to me as well many times. 😂

Yes, that syntax for the boolean field seems to work as well. I learned something new about the OData filter query of the List rows action, thanks for sharing 😀

Was this reply helpful? Yes No