Dynamics CRM Connector - ODATA Filters

[ojward]

Hey Team,

I have a few questions around the Dynamics CRM Connector for flow. - Do you have any documentation or info relating to how far the results for the ODATA filters have been implemented?

• I've successfully used a filter condition but interested to know if I can use the $expand property to return related entities.
  e.g. Query 'Accounts' and use $expand to retrieve the related 'Address' records? (1:N Relationship) - Will Flow be able to handle these results?

(e.g. Will it recognise this as a collection?

Cheers!

[v-yamao-msft · Accepted solution]

Hi Ojward,

It seems that ODATA filter query function has not been implemented yet, as flow is being improved and developed, you could submit a flow idea at “Flow Ideas”.

The link of "Flow Ideas" is:
https://powerusers.microsoft.com/t5/Flow-Ideas/Add-Branching-Logic-to-Flow/idi-p/1600

Best regards,
Mabel Mao

[Anonymous]

Hi, could you provide an example of a filter? I'm having some real issues and there is nothing online.

[Anonymous]

Same issue for me here. It is really frustrating having no samples about the odata filtering. 

I tried to get a filter running for a small xrm sample with a new entity registrations.

Nevertheless I get this error:

A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.new_event' and 'Edm.Guid' for operator kind 'Equal'.\",\r\n \"innererror\": {\r\n \"message\": \"A binary operator with incompatible types was detected.

This leads me to the question, how can I filter with guids? Is there an option for casting?

[Anonymous]

Hi Tofi,

I actually figured it out in my case. I had to use single quotes i.e. 

Address1_City eq 'Redmond'

I don't know if this will help you in your case.

[Anonymous]

Hi trevor,

Thanks for your response :).

In case of filtering for a guid it does not help :(. Nevertheless you are right by filtering for string values it is correct to use single quotes.

[DennisStahl]

  var query = "/api/data/v8.2/customeraddresses?$select=line1,line2,line3,stateorprovince,postalcode,city,country,county&$filter=parentid_account/accountid eq " + AccountId + " and addressnumber eq 1";

worked for me

[ojward]

_new_fieldnameid_value eq cc0f7474-cac6-e611-80ee-5065f38b03d1