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:-
I got this error on the modern UI:-
while if I switch to the classic experience, I will get some results with a warning message as follow:-
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?