I have a choice column "Position" which I am referencing in the new list view filter to create a bunch of different views for departments. Each department can only view certain relevant "Position" choices.

Every view I have made so far works fine, but for my last view, I have 19 choices that could be a possible selection that will show up for this departments view.

All of my other views had 6 or less options. In the filter section, I have filled in 10 options and the "show more columns" option disappears from adding more.

Why is that? And is there a way around this?

enter image description here

1 Answer 1


This is a default behavior of SharePoint.

You can only use 10 conditions in list view filter.

Workaround (Not tested):

Try setting the list view query using PowerShell: SharePoint Online: PowerShell to Update List View

View query requires CAML Query.

  • What if I created a broad value for the filter, then used a lookup column to determine the actual position?
    – BeerusDev
    Jun 22, 2021 at 15:52
  • It might work with "contains" operator in filter condition (as long as you have less than 10 conditions). But again users have to take care the selection of lookup value while creating/updating list items. Jun 22, 2021 at 15:56
  • Or... Can I have a different column with sub values, and have that column only show up when you are entering a new list item in a certain view?
    – BeerusDev
    Jun 22, 2021 at 16:02
  • Which version of SharePoint you are using? Are you using SharePoint default list forms or customized forms? Jun 22, 2021 at 16:05
  • I am using default
    – BeerusDev
    Jun 22, 2021 at 16:08

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.