Exceeded 5000 item limit in SharePoint

管理 アカウント 21 Reputation points
2021-04-28T16:58:24.23+00:00

Scenario: We exceeded the 5000 items limit in SharePoint in the threshold list.
Solution: we add indexes to existing columns (Title). But we don't know the limitation

  1. How many items can be acquired when an index is set for a column with API filter?
    let items = await sp.web.lists.getById(this.listId).items.filter(Title eq '${title}').top(?) **** [?] is the number of items
    ....
  2. How many items can be indexed? For example, we have a list with 20000 items. It's ok if we index all items. But I wonder if Indexing works when we have 3000000 items on the list.
    ....
  3. If we have 3000000 items (index column Title). Then i use api
    sp.web.lists.getById(this.listId).items.filter(Title eq '${title}').top(5000). Will it work normally?
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,061 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Allen Xu_MSFT 13,521 Reputation points
    2021-04-29T05:56:23.68+00:00

    Hi @管理 アカウント ,

    AFAIK there is no threshold on working with list items using REST API. So to your questions:

    1. You will get all items that meet the filter in the list.
    2. 30 million is the threshold for the count of items in a list. So all 3 million items can be indexed as they don't exceed the 30 million limitation.
    3. Yes, it will work normally.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.