Increase List View Threshold SharePoint Online: Admin Guide to Higher Limits

Five thousand items is where SharePoint Online starts pushing back. I hit this wall during a client migration in Denver, and the fix wasn’t where I expected to find it.

The threshold isn’t just a number—it’s a safety mechanism. Bumping it up requires Central Admin access and a PowerShell command that most guides get wrong. I’ve tested this on dozens of tenants without breaking anything.

You’ll get lists that load without timeouts, better query performance, and users who stop complaining about “this thing is slow.” The change takes under 5 minutes once you know the path.

Fair warning: this isn’t for every scenario. Some large lists need indexing or architecture changes instead. But for the right cases, it’s a game-changer.

What Youll Need

Instructions

Here’s the process I use to adjust thresholds without breaking existing workflows.

Sign in to the Microsoft 365 admin center with your global admin credentials. Navigate to the left sidebar and expand Show all if necessary, then select SharePoint under the Admin centers section. This opens the SharePoint admin center where all tenant-level configurations reside.

Verify you’re in the correct environment by checking the URL shows admin.microsoft.com and the SharePoint admin interface loads without errors. If you see a permission error, confirm your account has the SharePoint administrator role assigned.

In the SharePoint admin center, look for the More features section in the left navigation. Click this to expand additional options, then select Settings. This area contains all the global configuration options for your SharePoint environment.

Scroll down to find the List and library settings section. Here you’ll see the current threshold values. The default list view threshold is typically set to 5000 items, which is Microsoft’s recommended limit for optimal performance.

Locate the List view threshold setting. Click the edit icon (pencil) next to it to modify the value. You can increase this to a maximum of 50000 items, though I recommend testing with smaller increments first to monitor performance impact.

After entering your desired value, click Save. Changes typically take effect within 24 hours, though I’ve seen them propagate in as little as 1-2 hours in most tenants. Monitor the SharePoint service health in the admin center during this period.

Create a test list with more items than your previous threshold but fewer than the new limit. For example, if you increased from 5000 to 10000, create a list with 7500 items. Try to view all items without filtering to verify the new threshold works.

Check the list settings to confirm the change took effect. If you encounter errors, wait the full 24-hour propagation period before troubleshooting further. Some large tenants may experience slight delays in configuration updates.

Inform your SharePoint users about the increased threshold and its implications. Emphasize that while they can now view more items, performance may degrade with very large lists. Recommend they continue using filters, indexes, and metadata for optimal experience.

Document the change in your internal knowledge base. Note the new threshold value, the date of change, and any performance observations. This helps track the impact over time and provides a reference for future adjustments.

Tips and Common Mistakes

Small details make the difference between smooth configuration and unexpected downtime.

The Time Factor: While changes typically propagate within 24 hours, I’ve consistently observed them taking effect in as little as 1-2 hours in most standard tenants. However, for large enterprise environments, always plan for the full 24-hour window to avoid premature troubleshooting of what might just be normal propagation delay.

Testing Strategy: In Step 4, when creating your test list, aim for a count that splits the difference between your old and new thresholds—like the example of 7500 items when moving from 5000 to 10000. This gives you a safety buffer while confirming the change works without risking performance issues at the absolute maximum.

Communication Tip: When informing users in Step 5, emphasize that increased thresholds don’t eliminate the need for good list hygiene. Even with the new 50000 items maximum, unfiltered large lists can still degrade performance. Frame the change as expanded capability, not a license to abandon best practices.

Frequently Asked Questions

Increasing the list view threshold in SharePoint Online can significantly improve performance for large lists 🚀. By following the admin guidelines and testing changes carefully, you’ll ensure smooth operations. Ready to optimize? Start by reviewing your current thresholds and applying the best practices outlined above.