cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Dynamics CRM Connector - ODATA Filters

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Dynamics CRM Connector - ODATA Filters

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Community Support
Community Support

Re: Dynamics CRM Connector - ODATA Filters

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: Dynamics CRM Connector - ODATA Filters

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

Anonymous
Not applicable

Re: Dynamics CRM Connector - ODATA Filters

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?

2016-11-26 18_42_09-Eigene Flows verwalten _ Microsoft Flow.png

Anonymous
Not applicable

Re: Dynamics CRM Connector - ODATA Filters

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
Not applicable

Re: Dynamics CRM Connector - ODATA Filters

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
New Member

Re: Dynamics CRM Connector - ODATA Filters

  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

Microsoft
Microsoft

Re: Dynamics CRM Connector - ODATA Filters

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

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (8,429)