Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by

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)


jonclaylondon_0-1714380953447.png


Any help would be much appreciated.

Many thanks,
Jon




  • Expiscornovus Profile Picture
    31,889 Most Valuable Professional on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    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 😀

     

    booleanvalue.png

  • Chriddle Profile Picture
    7,793 Super User 2025 Season 1 on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

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


    Shouln't just

     

     

    sic_deceased

     

     

    be sufficient if its value is boolean?

  • Chriddle Profile Picture
    7,793 Super User 2025 Season 1 on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    😳

  • Expiscornovus Profile Picture
    31,889 Most Valuable Professional on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    Hi @Chriddle,

     

    This was Dataverse, not SharePoint 😉

  • Chriddle Profile Picture
    7,793 Super User 2025 Season 1 on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    odata filters in Sharepoint are weird 🙄

    Try

    sic_deceased eq 1
  • JonClay Profile Picture
    on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    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

  • Verified answer
    Expiscornovus Profile Picture
    31,889 Most Valuable Professional on at
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492