Exceeded 5000 item limit in SharePoint

Question

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?

Answer 1

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.