cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

ODATA filter using baseenum

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?

1 REPLY 1
Highlighted
Super User II
Super User II

Re: ODATA filter using baseenum

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

 

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

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
Users online (7,208)