There seems to be a little trick needed to filter CRM 365 ID GUIDs when using OData style filter expressions in the filter rows field

In my example I will use the CRM Orders entity and I am trying to get the following list of products in Power Automate:

I can see in XrmToolBox (AWESOME TOOL BTW) that the column I want to sort by is called salesorderid

So I would think the following syntax would work but it did not:

salesorderid eq GUID

Here is the correct way to filter

_salesorderid_value eq GUID

I had to add an underscore at the beginning of the column name and add _value at the end and now it filters just fine!!

 

Power Automate Error:

A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.salesorder' and 'Edm.Guid' for operator kind 'Equal'.

Reference:

https://powerusers.microsoft.com/t5/Building-Flows/A-binary-operator-with-incompatible-types/td-p/1141788