web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ODATA filter using bas...
Power Automate
Unanswered

ODATA filter using baseenum

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • manuelstgomes Profile Picture
    6,625 on at

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard