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

D365 Connector - Get Records - Filter Criteria with Odata

Hi All,

 

We have a requirement to move the Leads attachments to SharePoint.    Currently I am Using the Get Record Action to get the total leads and looping through each leads (with or without attachments) and then based on the Leads attachment, I create the files in SharePoint.   This takes a long time to get executed.

 

Is there a better way to query and filter ONLY Leads having attachments in the first Get Record Action - same as we can do in Dynamics 365?    When I tried with the OData query generator as I did in D365, it says ODATA doesnt support those query formats with linked query or filter criteria.  Is this a limitation in Flow with ODATA that we need to live with or a better way around? 

 

Please share your suggestions.

 

Lead Query.JPG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: D365 Connector - Get Records - Filter Criteria with Odata

 

Hi @Mustaque_Ehiya ,

 

Filter Query does not support such query statements.

Please refer to this blog for more details about Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

You need to use "and" and "or" to add multiple filters and replace "=" with "eq".

You could first execute the Get records action without configuring Filter Query, and then check the property name in the Body.

And there are restrictions on the field types in Filter Query. Only String and Number fields can be configured as filters.

 

Best Regards,

Community Support Team _ Barry
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

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: D365 Connector - Get Records - Filter Criteria with Odata

 

Hi @Mustaque_Ehiya ,

 

Filter Query does not support such query statements.

Please refer to this blog for more details about Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

You need to use "and" and "or" to add multiple filters and replace "=" with "eq".

You could first execute the Get records action without configuring Filter Query, and then check the property name in the Body.

And there are restrictions on the field types in Filter Query. Only String and Number fields can be configured as filters.

 

Best Regards,

Community Support Team _ Barry
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

Highlighted
Super User III
Super User III

Re: D365 Connector - Get Records - Filter Criteria with Odata

Hello,

You can speed up performance by enabling concurrency.

You can do this by clicking the 3 dots on a Apply to each action. Than click settings.
Turn on Concurrency and set value to 50.

Do this on all your apply to each loops.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others




Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new 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!

Top Solution Authors
Top Kudoed Authors
Users online (7,339)