Unanswered

Flow error, Filtering Data with OData GUID

(0) Share

Report

Posted on by Yruiz

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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Yruiz 29 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
sermormo 9 on at

Like (3)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Hubertus 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No