none
list view threshold inside our SharePoint online Communication Site document library. It is showing error on modern UI and showing warning message in classic UI RRS feed

  • Question

  • I am working on a SharePoint Communication modern site, and we have a document library that contains 8,500 files.

    Now since the documents are organized inside folders and sub-folders, so we did not face any issues regarding the list view threshold. But inside our document library, we have defined 2 managed metadata site columns named (Main Category & Sub Category) and we have the Managed metadata configured on this document library. Today I wanted to group all the documents based on these 2 managed metadata columns, by creating 2 list views. But when I tried to create the first view, and I defined to show all files without folders + group by the managed metadata site column + item limit of 4,500, as follow:- enter image description here

    I got this error on the modern UI:-

    enter image description here

    while if I switch to the classic experience, I will get some results with a warning message as follow:-

    enter image description here

    Although as shown inside my above picture I defined the item count inside the list view to be 4500, now I am happy to show only 4500 documents and group them by the "Main Category" managed metadata site column... so can anyone advise on this please? how I can overcome this error on modern UI and the warning message in classic UI?


    • Edited by johnjohn11 Thursday, November 14, 2019 11:16 AM
    Thursday, November 14, 2019 11:14 AM

Answers

  • Hi john,

    I have tested in my SharePoint Online communication site, if we only set Item limit settings in list view, it works as expected in both classic view and modern view. No error and warning in the list view page.

    But if I “Group” the items by a column, the list will firstly check if the number of items in this group exceeds list view threshold, if so, it will get the error without executing item limit settings.

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by johnjohn11 Monday, November 18, 2019 12:35 PM
    Monday, November 18, 2019 3:04 AM
    Moderator

All replies

  • Hi john,

    I test in a list in my SharePoint Online team site. The Item limit settings in list view works well to avoid list view threshold in both modern view and classic view.

    I will test in communication site and give an update for you.

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Friday, November 15, 2019 10:05 AM
    Moderator
  • Hi john,

    I have tested in my SharePoint Online communication site, if we only set Item limit settings in list view, it works as expected in both classic view and modern view. No error and warning in the list view page.

    But if I “Group” the items by a column, the list will firstly check if the number of items in this group exceeds list view threshold, if so, it will get the error without executing item limit settings.

    Best regards,

    Grace Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by johnjohn11 Monday, November 18, 2019 12:35 PM
    Monday, November 18, 2019 3:04 AM
    Moderator