SharePoint Document Issues

Fix SharePoint List 5,000 Item View Threshold for SQL Exports

Adam Davis Oct 16, 2026 869 views

Question details

The user needs to display and manage approximately 9,100 active client records exported from a SQL view into SharePoint without triggering the list view threshold error.

Fix SharePoint List 5,000 Item View Threshold for SQL Exports

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Using Power Automate to continuously export thousands of records from an on-premises SQL view into a SharePoint list.
Observed behavior: The SharePoint list fails to display all records simultaneously because the dataset exceeds the default 5,000-item view threshold limit.

Before you start

Before your list exceeds 5,000 items, identify which columns you will use to filter, sort, or group your data, as these columns must be indexed in advance.

Solution 1Recommended

Create Indexed Columns and Filtered Views

Bypass the view limit by indexing key columns and creating specific views that filter the total displayed items to under 5,000 at a time.

SharePoint can store up to 30 million items, but it limits the number of items queried in a single view to 5,000 to maintain server performance. Indexing columns allows SharePoint to quickly find filtered data without scanning the entire list.

Navigate to List Settings

Open your SharePoint list, click the gear icon in the top right corner, and select 'List settings'.

Create an Indexed Column

Scroll down to the Columns section, click 'Indexed columns', and then select 'Create a new index'. Choose the primary column you will use for filtering (e.g., Client Status or Date) and click 'Create'.

Set Up a Filtered View

Go back to List settings, scroll to the Views section, and click 'Create view' or edit an existing one. In the Filter section, select 'Show items only when the following is true' and use your newly indexed column to restrict the results (e.g., Status equals 'Active'). Ensure this filter keeps the returned items below 5,000.

Create Indexed Columns and Filtered Views

Index Before Hitting the Limit: It is highly recommended to create indexed columns before your list reaches 5,000 items. If the limit is already breached, you may need a site administrator to create indices using modern list experiences.

Solution 2

Configure Pagination in Power Automate

If your Power Automate flow is failing to process or update all 9,100 items, you must enable pagination on the data retrieval action.

Free Microsoft Office alternative

Analyze Large Exported Datasets Easily with WPS Office

While SharePoint is great for cloud storage, analyzing and manipulating lists with over 5,000 records can be restrictive. Export your large SharePoint lists to CSV or Excel and open them in WPS Office—a free, lightweight, and highly compatible Office alternative designed for smooth data handling without browser limits.

1. Download and Install: Visit the WPS Office website to download the free application for your operating system.
2. Export SharePoint Data: In your SharePoint list, click 'Export' and select 'Export to Excel' or 'Export to CSV'.
3. Analyze in WPS Spreadsheet: Open the downloaded file using WPS Spreadsheet to freely filter, sort, and analyze all 9,100+ records without view limitations.

Fully compatible with Microsoft Excel (.xlsx, .csv) formats for seamless data transition.Lightweight desktop application that handles tens of thousands of rows without lag.Familiar user interface makes it incredibly easy to transition and start working immediately.Completely free to use for core spreadsheet, document, and presentation tasks.

microsoft office alternative - wps office

Frequently Asked Questions

What is the absolute maximum capacity of a SharePoint list?

A single SharePoint list or library can hold up to 30 million items or files. However, the default view limit remains at 5,000 items to protect database performance during queries.

Why can't I just increase the 5,000-item threshold setting?

In SharePoint Online, the 5,000-item list view threshold is hard-coded by Microsoft to prevent performance degradation on shared cloud tenants and cannot be changed or manually increased.

How do I fix the view threshold error if my list already has over 5,000 items?

If you are locked out of making changes due to the threshold error, modern SharePoint automatically attempts to create indices in the background. If it fails, you may need to use Microsoft Access to connect to the list and edit the data, or delete items until the count falls below 5,000 so you can manually create indexed columns.

Document & File Issues