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)
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