I'm trying to filter a column of type lookup from a list using this method.

/_vti_bin/ListData.svc/Collections()?$expand=Departments&$filter=Departments/Title eq 'Sales'

And its outputting the following error:

<message xml:lang="en-US">No property 'Title' exists in type 'System.Collections.Generic.IEnumerable`1[[Microsoft.SharePoint.Linq.DataServiceEntity, Microsoft.SharePoint.Linq, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c]]' at position 12.</message>

And found out that below does work in displaying the departments title, through selecting, meaning title does exist.

/_vti_bin/ListData.svc/Collections()?$expand=Departments&$select= Departments/Title

Am I missing something to be able to filter from a multiple lookup column?


I assume it is by design. I can reproduce it if the lookup field can contain multiple references. If it is single lookup column, there is no error.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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