Answered

Filter query for dynamics fin & ops returning an error

(0) Share

Report

Posted on by Community Power Pla...

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:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,474 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... on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot @Expiscornovus , that worked.

Was this reply helpful? Yes No