SharePoint list item limitations

bernardine jessel 0 Reputation points
2026-11-19T14:59:24.9333333+00:00

We’ve been using SharePoint lists to manage internal data, and some of them are getting pretty large now. At what point do list size or the number of records actually start becoming a problem for views or performance?

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments

2 answers

Sort by: Oldest
  1. AI answer

    2026-11-19T14:59:41.7966667+00:00

    SharePoint lists and libraries can store up to 30 million items, but problems usually start much earlier at the List View Threshold (LVT).

    The key point is:

    • Around 5,000 items in a view or query is where list views and certain operations can start failing or slowing down.
    • If a view shows more than 5,000 items, SharePoint can return a list view threshold error.
    • This is not a hard storage limit for the list itself. It is a limit on how many items a database operation or query can process at one time.

    Why this happens:

    • SharePoint stores list data in SQL Server tables.
    • When a read or write operation locks more than about 5,000 rows at once, SQL Server may lock the whole table temporarily, which can hurt performance for everyone.
    • The threshold exists to protect overall system performance.

    What this means in practice:

    • A list can grow very large, even into the millions of items.
    • Performance issues usually show up when:
      • a view returns too many items,
      • filtering or sorting is not selective enough,
      • operations try to process all items at once.
    • Filtered views on large lists can still work well if they return a smaller subset of items.
    • Microsoft recommends using the modern experience for views that show many items, because it handles large lists better than the classic experience.

    Other relevant limits:

    • Maximum items in a list or library: 30 million
    • Maximum individual file or attachment size: 10 GB

    So, the practical answer is:

    • The list itself does not usually become a problem at 5,000 total records.
    • Views, queries, and operations become the problem when they need to work with more than about 5,000 items at once.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Jayden-P 4,465 Reputation points Independent Advisor
    2026-11-19T15:03:01.2866667+00:00

    Hi @bernardine jessel

    The AI answer provides some helpful information about SharePoint list scalability and the List View Threshold, so I'd recommend reviewing it carefully.

    One point I'd like to emphasize is that the commonly referenced 5,000-item threshold does not mean a SharePoint list is limited to 5,000 records. SharePoint Online can support much larger lists, and many organizations successfully work with hundreds of thousands of items.

    In most cases, issues arise when a view or query needs to process a large number of items at once. For example, displaying all items in a large list, or sorting and filtering on columns that aren't optimized for large datasets, can lead to performance issues or threshold-related errors.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.