web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : xVOHoxtlX4n9QBbMvPznOC
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Apr 2024 08:59:04 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
    32,177 Most Valuable Professional on 29 Apr 2024 at 12:15:13
    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,932 Super User 2025 Season 2 on 29 Apr 2024 at 12:05:43
    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,932 Super User 2025 Season 2 on 29 Apr 2024 at 11:55:40
    Re: Problem with filtering on a Boolean value when using "When a row is added, modified or deleted"

    😳

  • Expiscornovus Profile Picture
    32,177 Most Valuable Professional on 29 Apr 2024 at 10:12:37
    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,932 Super User 2025 Season 2 on 29 Apr 2024 at 10:10:38
    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 29 Apr 2024 at 09:56:42
    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
    32,177 Most Valuable Professional on 29 Apr 2024 at 09:10:58
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete