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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / A binary operator with...
Power Automate
Answered

A binary operator with incompatible types was detected

(0) ShareShare
ReportReport
Posted on by 78

Hi all,

 

I try to imitate an integration with a web store in Dynamics 365 CRM. I created a flow with which a lead is also created as a contact person. The first name, last name and lead number fields are copied from lead to contact at creation of a lead. With a second flow I try to transfer changes from a lead to the corresponding contact.
In the flow I initialize a variable called lead of the string type for the field "leadnummertkst". Then I use a filter query: new_contactpersoonnummertkst eq {x} lead. However, this filter gives this error message:
  "status": 400,
  "message": "A binary operator with incompatible types was detected.Found operand types 'Edm.String' and 'Edm.Int32' for operator child 'Equal'.",
  "source": "demo.crm4.dynamics.com",
  "errors": [],
  "debugInfo": "clientRequestId: e03e7c6b-7e1b-403b-97a9-73ae5e81389f"
}
This method works well when I replace the text fields "leadnummertkst" and "contactpersoonnummertkst" with fields of the data type integer.

 

Regards,  Jan

Categories:
I have the same question (0)
  • Verified answer
    v-yamao-msft Profile Picture
    on at

    Hi @Jan2,

     

    Could you share more details on your flow? How did you try to initialize a variable string?

    I have made the following test, please check it for a reference.

    The variable StringTest is of type String, and it returns a proper value.

    1.PNG

    Here is a blog on how to use variables, please check it for a reference:

    https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/How-Set-Variable-can-be-used-as-a-replacement-for-Set-Field-in/ba-p/79934

     

    Best regards,

    Mabel

  • Jan N Profile Picture
    78 on at

    Hi Mable,

    I try to imitate an integration with a web store in Dynamics 365 CRM. I created a flow with which a lead is also created as a contact. The first name, last name and lead number fields are copied from lead to contact at creation of a lead. With a second flow I try to transfer changes from a lead to the corresponding contact.
    In the flow I initialize a variable called lead of the string type for the field "leadnummertkst". Then I use a filter query: new_contactpersoonnummertkst eq {x} lead. However, this filter gives this error message:
      "status": 400,
      "message": "A binary operator with incompatible types was detected.Found operand types 'Edm.String' and 'Edm.Int32' for operator child 'Equal'.",
      "source": "demo.crm4.dynamics.com",
      "errors": [],
      "debugInfo": "clientRequestId: e03e7c6b-7e1b-403b-97a9-73ae5e81389f"
    }
    This method works well when I replace the text fields "lead leadnummertkst" and "contactpersoonnummertkst" with fields of the data type integer.

     

    flow.JPG

     

    Best regards, Jan

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard