A binary operator with incompatible types was detected

[Jan2]

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

[v-yamao-msft · Accepted solution]

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.

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-...

Best regards,

Mabel

[Jan2]

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.

Best regards, Jan