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?

1 Answer 1


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 we “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.

So for your issue, make sure that after you set first group, it don't exceeds list view threshold.

Similar issue post:


  • ok you are correct, as when i removed the group by + i changed the sort from Name to ID i am able to view the 5000 documents...
    – John John
    Nov 18, 2019 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.