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?

3 Answers 3


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?
    – Nina G
    Commented Sep 21, 2016 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
    Commented Sep 22, 2016 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.
    – Nina G
    Commented Sep 21, 2016 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. Commented Sep 21, 2016 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?
    – Nina G
    Commented Sep 21, 2016 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 and acknowledge you have read our privacy policy.

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