web

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

News and Announcements icon

Power Platform CommunityForums Power Automate ODATA filter using bas...

Power Automate

Unanswered

ODATA filter using baseenum

(0) Share

Report

Report

Posted on by ShawnT

Hello,

I am having trouble getting a flow process to recognize a baseenum value from Dynamics 365 for operations. I have setup a flow that uses a method to query a D365O data entity that I found online. The filter looks like the line below:

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

The flow execution doesn't create an error message, but the process does not return any results. If I remove the line, the process will return all the records from the purchase order line entity including the ones with purchStatus = 'Backorder' What am I mssing in this setup?

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @TomT

Your OData query is not correct. If the PurchaseOrderLineStatus is a string then you can compare it just by doing:

PurchaseOrderLineStatus eq 'Backorder'

Otherwise, you can add a compose and add the "Backorder" and filter it by using:

PurchaseOrderLineStatus eq outputs('<Name of the compose field>')

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No

Join the conversation