Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Flow error, Filtering Data with OData GUID

(0) ShareShare
ReportReport
Posted on by 29

I need to filter all the records of the entity "Cases" that are of a specific "Project". For this I used the "Enumerate records" and in the ODATA query:

iav_proyectoid eq '@ {triggerBody ()? [' _ iav_proyectoid_value ']}'

This gives me an error that can not compare a string value with a GUID value. I also used the
 
iav_proyectoid eq guid '@ {triggerBody ()? [' _ iav_proyectoid_value ']}'

Giving me a syntax error.

I have tried these same queries in the quotes, with the + symbol, and nothing.

The question is: Using the "Enumerate Registers" of dynamics, you can do this type of ODATA queries: List all the records that have a given value of a lookup field?

Thank you so much

 

 

 

  • Hubertus Profile Picture
    6 on at
    Re: Flow error, Filtering Data with OData GUID

    Thank you, after spending hours on this issue I found your hint here. Thanks, Thanks, Thanks

  • sermormo Profile Picture
    9 on at
    Re: Flow error, Filtering Data with OData GUID

    Hello there,

    I had a similar error during a ODATA user filter operation. In order to fixed, i had to removed the odata filter and look for the name of the field into the response. Doing that, I noticed that the lookup guid name have a different naming convention. So i had to modified the odata filter using the name convention listed on the response

    Please find next the steps that i did to figure this out:

    1. To Remove the odata filter and run the flow

    2. To check the API resutl json, and copy the output json into a text editor.

    3. To look for the guid value that i wanna filter. On my case i was filter opportunities based on ownerid. So i had to seek for ownerid. 

    4.Once i identifed the field name on the response i changed the name field  found in the response with the one i was using on the filter criteria. On my case i have to change ownerid for _ownerid_value. e.g _ownerid_value eq '[GUID-IDENTIFIER]'

    5. Test and run.

     

    i hope this helps you to fix your issue.

     

     

     

     

  • Yruiz Profile Picture
    29 on at
    Re: Flow error, Filtering Data with OData GUID

    Enumerar con GUID.pngerror con GUID.pngEnumerar sin GUID.pngerror sin GUID.png

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow