D365 Connector - Get Records - Filter Criteria with Odata

(0) Share

Report

Posted on by Mustaque_Ehiya

142

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No