cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Flow error, Filtering Data with OData GUID

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

 

 

 

2 REPLIES 2
Highlighted
Frequent Visitor

Re: Flow error, Filtering Data with OData GUID

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

Highlighted
Regular Visitor

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.

 

 

 

 

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!

Users online (7,662)