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... ?

I have the same question (0)

All responses (3)

Answers (0)

PabloCRP 1,088 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report

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

Was this reply helpful? Yes No