web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter query for dynam...

Power Automate

Answered

Filter query for dynamics fin & ops returning an error

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all,

I am using list items present in a table action in power automate from Dynamics Fin & ops connector and for some reason I am having issues with the filter query not working as per the expectation. Please see below for error of the screenshot.

I am not sure what this error means, when I execute the action without filter query, it works fine. Below is a part of json response referring to the field I mentioned in filter query.

can someone assist what to fix in the filter query? thanks in advance.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,768 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @Anonymous,

It looks like the property is a enum and not a regular string. As far as I can tell from the documentation this type of property needs a special syntax in your Filter Query:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata#using-enums

Can you try something like below:

PurchaseOrderLineStatus eq Microsoft.Dynamics.DataEntities.PurchStatus'Backorder'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot @Expiscornovus , that worked.

Was this reply helpful? Yes No

Join the conversation