SharePoint List View Threshold Blocks a Filtered View: What Site Owners Should Check

You built a filtered view in SharePoint to show only the items you need. But when you or your team members open that view, you see an error instead of the filtered data. The error says the view exceeds the list view threshold, which is 5,000 items for a default SharePoint list or library.

This happens because SharePoint calculates the view threshold based on the number of items in the root folder of the list, not the number of items returned by your filter. Even if your filter returns only 50 items, SharePoint first scans the entire list to apply the filter. If the list has more than 5,000 items, the view is blocked.

This article explains why the list view threshold blocks filtered views and what site owners can check to resolve the issue. You will learn about indexed columns, folder structures, and alternative methods to work around the threshold without changing the entire list architecture.

Why the SharePoint List View Threshold Blocks a Filtered View

The list view threshold is a SharePoint performance limit set to 5,000 items per list or library for a single database query. When you open a view, SharePoint runs a query against the content database. If the query must scan more than 5,000 items before applying your filter, the query is blocked to prevent database performance issues.

The root cause is that SharePoint does not apply the filter until after it scans the list. Even if your filter is precise, SharePoint first reads all items in the root folder. If that folder contains more than 5,000 items, the query fails. This applies to both default views and custom filtered views.

A common misunderstanding among site owners is that a filtered view avoids the threshold because it returns fewer items. But the threshold check happens before filtering. The only way to bypass the threshold is to ensure SharePoint can locate the filtered items without scanning the entire list.

Steps to Check and Fix Filtered Views Blocked by the Threshold

Site owners need to check three areas: the list size, the filter column, and whether indexed columns exist. Follow these steps to diagnose and resolve the issue.

1. Check the total item count in the list
   Go to the list or library. Click the gear icon and select List settings or Library settings. Scroll to the bottom of the settings page. The total number of items appears under General settings or in a summary section. If the count exceeds 5,000, the threshold is active.
2. Identify the column used in the filtered view
   Open the view that is blocked. Note the filter criteria. For example, the filter might be Status equals Active or Region equals West. The column used in the filter is the key column for your fix.
3. Add an index to the filter column
   In List settings, click Indexed columns. Click Create a new index. Select the column from step 2. Click Create. After the index is built, the filtered view will use the index to find matching items without scanning the entire list. The view should now load correctly.
4. Test the filtered view
   Return to the list and open the filtered view. The view should display the filtered results. If the view still fails, the filter might combine multiple columns. You may need to create a combined index or simplify the filter.
5. If indexing does not work, restructure the list with folders
   Create folders in the list. Move items into folders so each folder contains fewer than 5,000 items. Create a view scoped to a specific folder. In the view settings, under Scope, select Show items in this folder and all subfolders. This limits the query to the folder content.

If SharePoint Still Blocks the Filtered View After Indexing

The filter uses multiple columns and the index covers only one

When a view filter combines two or more columns, a single-column index might not help. SharePoint scans the list until it finds items matching the first indexed column, then applies the second filter. If the first column returns many items, the scan still exceeds 5,000. Create a combined index if the list is in SharePoint Server 2016 or later. In SharePoint Online, combined indexes are not available. Instead, simplify the filter to use only the indexed column, or create a separate view for each filter value.

The list contains more than 30,000 items

For very large lists, indexing alone may not be enough if the filtered column has low selectivity. For example, a column with only two unique values like Yes or No returns half the list. If half the list is 15,000 items, the query still scans more than 5,000 items. In this case, use folders to split the list into smaller chunks, or migrate the data to a separate list or a Power App.

The view still shows an error after indexing

Wait 10 to 15 minutes after creating the index. SharePoint needs time to build the index. Also verify that the view uses the exact column you indexed. If the view uses a different column, create an index for that column. Check the list settings page to confirm the index exists.

Item	Indexed Column	Folders
Description	Adds a database index to a single column for faster filtered queries	Divides items into containers so each container stays under 5,000 items
Best for	Lists with up to 30,000 items and a filter column with many unique values	Lists of any size where items can be logically grouped
Limitation	Does not work for multi-column filters in SharePoint Online	Breaks existing views and workflows that rely on flat item structure
Setup time	5 minutes plus 10-15 minutes for index creation	30 minutes to 1 hour depending on item count

As a site owner, you now know how to check the list size, add an index to the filter column, and restructure with folders when indexing fails. Start by checking the total item count and the filter column used in the blocked view. If the list has fewer than 30,000 items and the filter column has many unique values, adding an index is the fastest fix. For lists with more than 30,000 items or filters with low selectivity, plan to use folders or archive old items. One advanced tip: in SharePoint Online, you can use a Power Automate flow to move items older than a specific date to a separate archive list, keeping your active list under the threshold permanently.