question

03702433 avatar image
0 Votes"
03702433 asked 03702433 edited

Exceeded 5000 item limit in SharePoint

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?

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered 03702433 edited

Hi @03702433,

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@03702433,

Is there any update on this thread? I;m looking forward to your reply.
If an answer is helpful to you, please accept it as answer.

0 Votes 0 ·

Thanks Allen Xu_MSFT

But currently. I see the limitation for filter query is 5000?

0 Votes 0 ·