List View Threshold Blocks a Filtered View: Root Cause and Fix

When you open a filtered view in a SharePoint list, you may see an error message stating that the view is blocked because it exceeds the list view threshold. This happens even when the filter should reduce the number of items shown. The root cause is that SharePoint evaluates the total number of items in the list before applying the filter, and if that total exceeds 5,000 items, the view is blocked. This article explains why the threshold applies to filtered views and provides a step-by-step fix to regain access to your data.

Why the List View Threshold Blocks Filtered Views

SharePoint has a built-in limit called the list view threshold. This limit is set to 5,000 items by default for lists and libraries. The threshold exists to protect server performance. When a view is opened, SharePoint must calculate the total number of items in the list before it can apply any filter. If the total item count exceeds 5,000, the view is blocked regardless of the filter criteria. The filter is not applied because the initial count operation already hits the limit.

This behavior surprises many users. They expect a filter that returns only 100 items to work fine. But SharePoint does not evaluate the filter first. It checks the list size first. If the list has 10,000 items, any view — even one filtered to show a single item — is blocked. The only way to bypass this is to create an index on the column used in the filter. An index allows SharePoint to use a more efficient query that applies the filter before counting the total items.

The Role of Column Indexes

A column index is a database structure that speeds up queries on that column. When you add an index to a column and then create a view that filters on that column, SharePoint can use the index to retrieve only the matching items. This avoids the full list scan that triggers the threshold error. Indexes do not change the list content. They only change how SharePoint queries the data.

Steps to Fix the Blocked Filtered View

To fix a filtered view that is blocked by the list view threshold, you must add an index to the column used in the filter. After adding the index, you may also need to adjust the view settings to use the index. Follow these steps exactly.

Method 1: Add an Index on the Filtered Column

This method works for any list or library. You need at least Edit permissions on the list.

1. Open the list settings
   Navigate to the list that has the blocked view. Click the gear icon in the top right corner and select List settings. If you are in a modern list, click the Settings gear and choose List settings from the menu.
2. Locate the Columns section
   Scroll down to the Columns section. You will see a list of all columns in the list. Find the column that your filtered view uses. For example, if your view filters on Status, find the Status column.
3. Click the column name
   Click the name of the column to open its settings page.
4. Enable the index
   Scroll down to the Indexed section. Select Yes for Indexed. If you are using a modern list, you may see a toggle labeled Indexed. Turn it on.
5. Save the column settings
   Click OK or Save at the bottom of the page. SharePoint will create the index. This process may take a few minutes for large lists.
6. Test the filtered view
   Go back to the list and open the filtered view. The view should now load without the threshold error.

Method 2: Create a New View That Uses the Indexed Column

If the existing view still fails after adding the index, create a new view that explicitly uses the indexed column in its filter.

1. Go to the list and click the view switcher
   In the top right of the list, click the current view name. From the dropdown, select Create new view.
2. Choose a view type
   Select Standard view or Calendar view depending on your needs. Click Create.
3. Set the filter to use the indexed column
   In the view settings page, scroll to the Filter section. Add a filter on the indexed column. For example, set Status equals Active. Make sure you use the same column you just indexed.
4. Save the view
   Click OK. Name the view something like Active Items. Apply the view to test it.

Method 3: Use a Site Column with an Index

If you manage multiple lists that need the same indexed column, create a site column with indexing enabled. This saves time and ensures consistency.

1. Go to Site settings
   Click the gear icon and select Site settings. Under Web Designer Galleries, click Site columns.
2. Create a new site column
   Click Create. Fill in the column name and type. Check the option Indexed. Click OK.
3. Add the site column to your list
   Open your list settings. Under Columns, click Add from existing site columns. Find the column you created and add it. The index carries over automatically.
4. Update your filtered view
   Edit the view to filter on the new site column. The view should now work.

If the Filtered View Still Does Not Work

Sometimes the fix does not work immediately. The following issues may cause the filtered view to remain blocked.

The Index Column Is Not Used in the Filter

An index only helps if the view filter uses the exact indexed column. If the view filters on a different column, the index has no effect. Check the view filter settings. Ensure the filter column matches the indexed column exactly. Also verify that the filter uses a simple operator such as equals, is less than, or contains. Complex filters with OR conditions may still fail.

The Index Takes Time to Build

For lists with many items, creating an index can take several minutes. If you test the view immediately after adding the index, the index may not be ready. Wait 10 to 15 minutes and then test the view again. You can check the index status by opening the column settings. If the Indexed option shows Yes, the index is active.

The List Exceeds 30,000 Items

SharePoint has a second limit of 30,000 items for indexed queries. If your list has more than 30,000 items, even an indexed filter may fail. In this case, you must reduce the list size. Archive old items to a separate list, or split the list into multiple lists based on categories such as year or department. After reducing the count below 30,000, the indexed filter will work.

The View Uses a Folder Structure

If the list uses folders, the threshold applies differently. Folders do not bypass the threshold. A filtered view that includes items from multiple folders may still hit the limit. To fix this, ensure the filter column is indexed and the view does not include all folders. Use the Show items in all folders option with caution.

Item	Without Index	With Index
Filter on Status column	Blocked if list exceeds 5,000 items total	Works for lists up to 30,000 items
Filter on Date column	Blocked if list exceeds 5,000 items total	Works for lists up to 30,000 items
Filter on multiple columns	Blocked unless all filter columns are indexed	Works if at least one indexed column is used with AND filter
List size 10,000 items	All views blocked	Filtered views on indexed columns work

You can now fix blocked filtered views by adding an index to the column used in your filter. After creating the index, update the view to use that column. For lists with more than 30,000 items, archive or split the data. To prevent this issue in the future, add indexes to columns that are commonly used in filters before the list reaches 5,000 items. You can also set up a retention policy to automatically archive old list items, keeping your active list under the threshold.