Microsoft Dynamics 365 | Integration, Dataverse...

Filter my lookup field by name through odata

(0) Share

Report

Posted on by Community Member

Hi, I am able to fetch data query by lookup field by ID : https://<myTenantURL>/_odata/auditset?$filter=cyno_account/Id eq (guid'356712b6-a0be-ea11-a812-000d3a378ab9'). But i want lookup field based on name please help... ?

All responses (3)

Answers (0)

Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report

RE: Filter my lookup field by name through odata

Hi,

Thank you for your query.

Filters on Single-valued navigation properties (Lookups) are applied using IDs (as far as I know).

Furthermore, it is not a good idea to search using name (as it can return duplicates).

I would recommend you to reverse your query, that means, queary on cyno_account and then expand on Auditset.

You can use any or all operator to expand on child entities using filters:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/query-data-web-api#any-operator
Community Member on at

Like (0)

Report

RE: Filter my lookup field by name through odata

Thanks I have tried this before but it is not working and displaying error ->This XML file does not appear to have any style information associated with it. The document tree is shown below.
PabloCRP 1,088 on at

Like (0)

Report
RE: Filter my lookup field by name through odata

Hi Ashishjoshi98,

you could do something like

$filter=cyno_account/cyno_name eq 'CONTOSO'

regards

please consider marking as an answer if it was helpful