There is a SharePoint list with a lookup column. Now I want to search the SharePoint list with filter on lookup column. E.g. :

https://sharepoint.com/sites/sitename/_api/web/lists/GetByTitle('listname')/items?$expand=lookupcolumn&$select=Title,parentlookupcol/lookupcolumn&$filter=substringof('US2017 - 0002',lookupcolumn) 

Syntax filter = lookupcolumn eq 'value' is working, but I want to filter the list even if I pass part of the string.

Please share an example of how I can achieve this.

Thanks in advance usha

1 Answer 1


isn't the problem that you are filtering by the lookupcolumn value and not the lookup column Title?

you'll have to expand the lookupcolumn and apply the filter to the text field

Expanding columns in lookup fields


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.