cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carterbarry88
Advocate I
Advocate I

Issue with Boolean / Two Option Set field. A binary operator with incompatible types was detected.

I came across the following issue with my trigger:

 

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

 

I was trying to do the following for the filter expression:

 

new_booleanfield eq 1

1 ACCEPTED SOLUTION

Accepted Solutions
carterbarry88
Advocate I
Advocate I

In order to fix this, I changed the filter expression to new_booleanfield eq true

 

You cannot use the option set value for the boolean field. You have to use true or false values

View solution in original post

2 REPLIES 2
carterbarry88
Advocate I
Advocate I

In order to fix this, I changed the filter expression to new_booleanfield eq true

 

You cannot use the option set value for the boolean field. You have to use true or false values

iantaylor01
New Member

I used not(yesnofield) in my filter as the yes/no field is true or false already and so it does not require a logical test to see if it is true. So the field alone should work if set to yes and not(yesnofield) if you only want to trigger if the field is No.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,871)