SharePoint Document Issues

How to Fix SharePoint List Access Errors Above 5,000 Items

Aamir Naveed AkramAamir Naveed Akram Nov 4, 2026 869 views

Question details

Users encounter list view threshold errors when attempting to access, sort, or filter a SharePoint list that contains more than 5,000 items.

How to Fix SharePoint List Access Errors Above 5,000 Items
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Attempting to view or manipulate a large SharePoint list, particularly one connected to Microsoft Forms or Power Automate workflows.
Observed behavior
SharePoint displays an error because the query attempts to process more than 5,000 records at once, preventing users from viewing or managing the list data.
Before you start

Ensure you have Site Owner or List Administrator permissions, as creating indexed columns and modifying public list views require elevated access.

Solution 1Recommended

Create Indexed Columns and Apply Filtered Views

Indexing columns allows SharePoint to quickly query data without scanning the entire list, bypassing the 5,000-item threshold limit.

In SharePoint, the list view threshold is a performance protection mechanism. By creating an index on a specific column and then filtering your view based on that column, you ensure the database only retrieves a subset of records.

1
Access List Settings

Navigate to your SharePoint list, click the gear icon (Settings) in the top-right corner, and select 'List settings'.

2
Create an Indexed Column

Scroll down to the Columns section and click 'Indexed columns'. Click 'Create a new index', select the column you want to filter by (e.g., Created Date or Status), and click 'Create'.

3
Modify the List View

Return to your List settings, scroll down to 'Views', and select the view you want to fix. Scroll to the 'Filter' section.

4
Apply the Filter

Set the filter to show items only when the indexed column meets specific criteria (e.g., 'Created' is greater than '[Today]-30'). Ensure this filter returns fewer than 5,000 items, then click 'OK' to save.

Create Indexed Columns and Apply Filtered Views
Index Limit: You can create up to 20 indexed columns per SharePoint list, but it is best to only index the columns you actively use for filtering or sorting.
Free Microsoft Office alternative

Analyze Massive Datasets with WPS Office

While SharePoint lists have strict viewing thresholds online, you can export your data to analyze it locally. WPS Office is a free, lightweight alternative to Microsoft Office that easily handles massive datasets and complex spreadsheets without lagging.

  1. 1. Download WPS Office: Install WPS Office for free from the official website to your device.
  2. 2. Export SharePoint Data: In your SharePoint list, click 'Export' and select 'Export to Excel'.
  3. 3. Analyze Locally: Open the downloaded .iqy or .xlsx file in WPS Spreadsheet to filter, sort, and analyze all your records without threshold limitations.
Free and lightweight Office alternative100% compatible with Microsoft Excel (.xlsx) formatsEasily handle exported SharePoint lists with hundreds of thousands of rowsFamiliar user interface requires no learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Can the 5,000-item SharePoint threshold be overridden?

In SharePoint Online, the 5,000-item list view threshold is a hard limit set by Microsoft to ensure server performance and cannot be permanently overridden. You must manage data using indexed columns, folders, or filtered views.

Will dividing a list break my Power Automate flows connected to Microsoft Forms?

No. As long as you keep the primary SharePoint list intact (the one your flow targets for new Forms responses), your workflow will continue to function. You can create a separate automated flow to regularly move older records to a secondary archive list.

Why does changing the view not resolve the threshold error?

If your new view sorts or filters based on a non-indexed column, SharePoint still has to scan the entire list to find the matching items. If the total list size is over 5,000, this full-scan query triggers the threshold error regardless of how many items the view is supposed to display.