Migration issue for list having thousands of items

asked 2022-06-14T06:34:56.337+00:00
sns 7,221 Reputation points

Source list ( on premises has 20000 items ) after migrating to online it is showing 1100 items,
what needs to be done to fix this issue? Please help

I can see below warning message on the list:
The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,977 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-06-15T09:04:32.347+00:00
    Xuyan Ding - MSFT 5,856 Reputation points Microsoft Employee

    Hi @sns ,

    If you are retrieving more than 5000 items or files at once in a single view, you will see an error message due to performance settings when retrieving items from large SharePoint lists.
    You could try the following:

    1. You can use the modern experience of lists. Pagination works differently compared to the classic experience. As you continue to scroll in the view it will load the items.
    2. If the data in the list is larger then try to split the data into multiple lists.
    3. Create multiple list views or add filters to views.
    4. Add an index to the list column, and SharePoint automatically plays some role in the SQL server, allowing it to quickly analyze and return values that bypass the threshold. Or enable automatic index management in a list or document library, if set to daily it will automatically create an index when the list item exceeds 2500.
      All in all, the above methods are all designed to return results with less than 5000 items after a particular view of the list has been retrieved.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.