Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5QAd522xAM8hPXnux0PbQB
Power Automate - Using Flows
Unanswered

Flow error, Filtering Data with OData GUID

Like (0) ShareShare
ReportReport
Posted on 30 Jul 2018 08:58:17 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 16 May 2024 at 14:34:26
    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 03 Jul 2019 at 17:12:05
    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 30 Jul 2018 at 08:59:40
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

#1
KD-02050901-0 Profile Picture

KD-02050901-0 2

#1
VictorIvanidze Profile Picture

VictorIvanidze 2

Overall leaderboard

Featured topics

Restore a deleted flow
Loading started