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
Thank you, after spending hours on this issue I found your hint here. Thanks, Thanks, Thanks
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.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional