cancel
Showing results for 
Search instead for 
Did you mean: 

SharePoint - ODATA filtering by lookup values

Is there any appetite for allowing ODATA filtering by lookup column values? I appreciate the option to 'filter the array' can be used after the query is run, this is far to slow to use over a large list.

Status: New
Comments
Advocate V

Hey @Paul_CJ, in this thread - https://powerusers.microsoft.com/t5/Building-Flows/OData-Filter-Query-on-SharePoint-Lookup-Site-Colu... - JackWert, on Oct. 17, 2018, clarified that this can be done, with the following syntax:

Super simple solution to this:

InternalFieldName/Title eq 'Lookup Value'

or

internalFieldName/Id eq 'Lookup Id'

 Hope this helps!
Josh