Sharepoint says the "Specified list is invalid, The specified list might have been deleted or you might not have permission to view it. Contact the site owner for more information."

Connor Steer 1 Reputation point
2022-04-13T18:52:44.553+00:00

I need to access Sharepoint but am getting this result when trying. I have seen that this may be a result of having 5000+ items in the sharepoint (which may be the case), and that the solution is to perform a health check, however, since I am doing this through a student account I am unable to perform one since I am not set up as an administrator. How can I fix this?

192842-image.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,893 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,471 Reputation points
    2022-04-14T03:11:53.427+00:00

    Hi @Connor Steer
    List View Threshold is a limit of 5000 items in SharePoint Online, which can’t be exceeded! Although SharePoint Online can store up to 30 million items, when a list view tries to show more than 5000 items, you’ll get an error, this is by design. We can’t change the list view threshold in SharePoint Online. The number 5000 is fixed and controlled by Microsoft to ensure better performance in SharePoint Online, as it operates as a shared tenant environment.

    We could only try to prevent this item limit threshold issue, such as:

    1. Set filters through “Modify list view” and limit the number of items in the view to less than 5000 to mitigate this issue. You can categorize your list items based on metadata whichever present in the list such as category, department, business function, etc.
    2. Archive old list items of files either by moving to a new list or a folder inside the same list.
    3. Add Indexed columns to the list.
    4. Remove default sorting, filters, group by, total settings in the list view (Set them to “none”). Reduce the number of columns in the view.

    For more information, you could refer to;
    https://www.sharepointdiary.com/2017/02/list-view-threshold-in-sharepoint-online-faq.html
    https://www.mrsharepoint.guru/resolve-the-sharepoint-item-limit-threshold/

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    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.