How to Fix SharePoint List Access Errors Above 5,000 Items
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.

- 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.
Ensure you have Site Owner or List Administrator permissions, as creating indexed columns and modifying public list views require elevated access.
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.
Navigate to your SharePoint list, click the gear icon (Settings) in the top-right corner, and select 'List settings'.
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'.
Return to your List settings, scroll down to 'Views', and select the view you want to fix. Scroll to the 'Filter' section.
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.

Archive Older Records to a Separate List
Moving historical data to an archive list keeps your active SharePoint list well below the 5,000-item threshold.
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. Download WPS Office: Install WPS Office for free from the official website to your device.
- 2. Export SharePoint Data: In your SharePoint list, click 'Export' and select 'Export to Excel'.
- 3. Analyze Locally: Open the downloaded .iqy or .xlsx file in WPS Spreadsheet to filter, sort, and analyze all your records without threshold limitations.

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.




