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: