I have a list with a column called Function that is of type Lookup. I try to create a view in the list and I attempt to Filter below:

enter image description here

I click OK at the bottom of the page and I get the below error:

enter image description here

It tells me that filtering on a column of type Lookup is not supported. Is there a work around to this or is there a different way that I can create a view that filters on my Function column?


You could create another column of type Single Line of Text and create a workflow that automatically runs on Add and Update that copies the value of the lookup column to it, then filter on that column.

  • That sounds good but what about the other 160 items I have on the list prior to making the workflow and the single line of text? That means I would have to manually start for all in order to make sure I can capture everything and not just current items on the list?
    – witness777
    Sep 21 '16 at 15:53
  • 1
    @Aspire27 there are a variety of ways to deal with that. A brute force way is to edit the existing items in data sheet view and paste a dummy value in the new field all the way down In each row. That will force the workflow to run on each row and overwrite the dummy value with the lookup value. You can also find Powershell scripts on the web that iterate through a list and run a workflow on each item, or really you just need to run Update() on each row.
    – mannaggia
    Sep 22 '16 at 0:56

It is telling you the contains operator is not valid in this configuration, you can filter using lookup columns, but you are restricted to equals or not equals.

So you'd need to create a view with a filter of your columns equals AGNXYZ or your column equals AGNABC, etc

  • Hi Eric. The only issue with that is with Equal To it has to be the exact text. So if in my column Function if I have entries that are Travel, Travels and Travelers then this won't work. If I set the filter to equal to TRAV, it doesn't pick up any if the aforementioned examples.
    – witness777
    Sep 21 '16 at 15:52
  • I know, you have to be explicit, because of the limitation that you cannot use the contains operator in a lookup column filter. Which is why I said it isn't valid, and you have to use equal to. Sep 21 '16 at 16:09
  • I understand. I have 20 items that I want to display in my view but filtering only allows me to do 10 filters max it seems like. Is there a workaround you could suggest?
    – witness777
    Sep 21 '16 at 16:15

I guess you need to modify the list view using SharePoint Designer. Using SPD one can write CAML query to fetch records for list view. Refer this link

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.