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