none
SharePoint list limitations RRS feed

  • Question

  • Hi all

    I have a SharePoint list which has exceed the 5000 item limit. I understand this is a view limit and SharePoint will hold millions of entries.

    I need to figure out how to create a second view as my 'All items' view feeds into an excel doc which I need for reporting. e.g. I need the 'All items' view always displaying all items.

    When I try to create a new view I get an error message:

    "This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator."

    I was hoping within the view I could display items only if column A =123... Through the view settigns. Its not allowing me to do this. I've also tried to index columns but I get the same error.

    Whats the way around this?

    Thanks in advance

    Simon

    Tuesday, November 3, 2020 4:13 PM

All replies

  • https://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-online/connect-sharepoint-online?view=sharepoint-ps

    hassansayedissa

    Tuesday, November 3, 2020 6:07 PM
  • Hi Simon,

    The SharePoint Server products and SharePoint Online services forums have transitioned to Microsoft Q&A, 
    https://docs.microsoft.com/en-us/answers/products/m365

    I am writing this reply to inform you that I have created a question in the Q&A for your issue here.

     You could go have a check and communicate with community memebers there.

    Best Regards,

    Michael Han


    "SharePoint" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "SharePoint" forums' new home on Microsoft Q&A !

    Wednesday, November 4, 2020 2:47 AM