M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions→ m365con.net

List view threshold (SharePoint)

Concept

The SharePoint limit, 5,000 items by default, on how many list items a single database operation such as a view query can process at once; it does not cap how many items a list can store.

✦ CONCEPTList view threshold(SharePoint)M365.FM
Title graphic: List view threshold (SharePoint) (Concept)
TypeConcept
Documentationlearn.microsoft.com/en-us/troubleshoot/sharepoint/lists-and-libraries/items-exceeds-list-view-threshold

Key points about List view threshold (SharePoint)

Episodes about List view threshold (SharePoint)

When to Move Power Apps from SharePoint to Dataverse

2025-11-26 · Video on YouTube

In this episode, we break down the myth that “SharePoint lists are a database for Power Apps” and show why that belief quietly kills performance, scalability, and data integrity. You’ll learn exactly where SharePoint list–backed Power Apps fall apart…

Articles about List view threshold (SharePoint) (1)

Frequently asked questions

Why are SharePoint lists a poor database for Power Apps?

They hit delegation limits, the 5,000-item list view threshold, non-delegable filters and costly item-level permissions. Complex queries run on the client, hurting performance and integrity. · From the episode: When to Move Power Apps from SharePoint to…

What is the 5,000-item list view threshold?

It is a SharePoint limit on list views that affects larger lists. The episode names it among the places where list-backed Power Apps fall apart as data and users grow. · From the episode: When to Move Power Apps from SharePoint to…

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Sources

Maintained by Mirko Peters (Microsoft MVP) · Last updated: