Modern document library view Group By not collapsing or showing second level

%3CLINGO-SUB%20id%3D%22lingo-sub-722249%22%20slang%3D%22en-US%22%3EModern%20document%20library%20view%20Group%20By%20not%20collapsing%20or%20showing%20second%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-722249%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20document%20library%20with%2015200%20documents%20in.%20Content%20Type%20with%20a%20number%20of%20single%20line%20text%20columns.%20I%20have%20tried%20to%20group%20by%20these%20columns%20with%20collapse.%20no%20filter%20so%20display%20all%20documents.%20I%20have%20another%20document%20library%20with%20fewer%20than%20300%20documents%20displaying%20a%20similar%20behaviour.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ETwo%20issues%3A%3C%2FP%3E%3CP%3E-%20default%20collapse%20on%20open%20has%20no%20effect%3C%2FP%3E%3CP%3E-%26nbsp%3B%202nd%20group%20by%20does%20not%20show.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20latest%20version%20Chrome.%20I%20have%20also%20tried%20launching%20the%20document%20library%20in%20Guest%20Mode.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20missing%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20364px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120727iFC1465157385E21D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22no%20collapse.PNG%22%20title%3D%22no%20collapse.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20652px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120728i27D96D8624A678AC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22groupby.PNG%22%20title%3D%22groupby.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-722249%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724807%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20document%20library%20view%20Group%20By%20not%20collapsing%20or%20showing%20second%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724807%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139670%22%20target%3D%22_blank%22%3E%40John%20Seto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20replicate%20your%20configuration%20and%20it's%20working%20with%20less%20than%20a%20100%20files.%20As%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmanage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eofficial%20documentation%3C%2FA%3E%20remarks%2C%20some%20list%20view%20options%26nbsp%3Bcould%20not%20be%20available%20nor%20working%20when%20the%20list%20or%20document%20library%20has%20more%20than%205000%20items%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20777px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121473i03E117D3DBF0E347%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-06-27%2013_15_18-Window.png%22%20title%3D%222019-06-27%2013_15_18-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20it%20helps!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724816%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20document%20library%20view%20Group%20By%20not%20collapsing%20or%20showing%20second%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F131856%22%20target%3D%22_blank%22%3E%40Ferran%20Chopo%20Garcia%3C%2FA%3E%26nbsp%3B-%20thanks%20very%20much.%20I%20will%20feed%20this%20back%20to%20client.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20migrate%20from%20Lotus%20Notes%20Databases%20which%20doesn't%20seem%20to%20have%20issue%20group%20by%20with%2013000%20items.%20It%20maybe%20legacy%20but%20still%20works%20on%20large%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-724973%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20document%20library%20view%20Group%20By%20not%20collapsing%20or%20showing%20second%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-724973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139670%22%20target%3D%22_blank%22%3E%40John%20Seto%3C%2FA%3E%26nbsp%3B-%20i%20am%20also%20finding%20this%20to%20be%20true%20with%20lists%20with%20only%20a%20couple%20hundred%20items.%20Grouped%2Fexpand%2Fcollapse%20does%20not%20appear%20to%20be%20ready%20for%20the%20modern%20UI.%20It's%20pretty%20frustrating.%20I've%20had%20lots%20of%20clients%20go%20back%20to%20folders%20for%20now%20so%20their%20users%20don't%20abandon%20SharePoint%20altogether.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281970%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20document%20library%20view%20Group%20By%20not%20collapsing%20or%20showing%20second%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281970%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19689%22%20target%3D%22_blank%22%3E%40Kelly%20E%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I'm%20replying%20to%20a%202%20year%20old%20thread%2C%20but%20I%20recently%20had%20this%20issue%20and%20after%20much%20struggling%20I%20got%20it%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20solution%20was%20to%20change%20the%20filtering%20(not%20the%20grouping).%20Although%20I%20was%20already%20filtering%20by%20indexed%20columns%2C%20I%20had%204%20criteria%2C%20with%20a%20mix%20of%20and%20and%20or%20logic%2C%20and%20used%20begins%20with%20for%20some%20items.%20Simplifying%20the%20filtering%20resolved%20the%20issue.%20I%20think%20it%20is%20because%20when%20loading%20ungrouped%20data%20it%20can%20load%20incrementally%2C%20and%20tolerate%20more%20complicated%20filters%2C%20but%20when%20grouping%20it%20must%20load%20all%20data%20at%20once%20and%20gets%20overwhelmed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20switched%20to%20using%20And%20logic%20exclusively%2C%20and%20avoided%20begins%20with%2C%20and%20it's%20working%20now.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a document library with 15200 documents in. Content Type with a number of single line text columns. I have tried to group by these columns with collapse. no filter so display all documents. I have another document library with fewer than 300 documents displaying a similar behaviour. 

Two issues:

- default collapse on open has no effect

-  2nd group by does not show.

 

I am using latest version Chrome. I have also tried launching the document library in Guest Mode.

 

Am I missing something?

 

no collapse.PNGgroupby.PNG

4 Replies

Hi @John Seto 

 

I tried to replicate your configuration and it's working with less than a 100 files. As the official documentation remarks, some list view options could not be available nor working when the list or document library has more than 5000 items:

 

2019-06-27 13_15_18-Window.png

Hope it helps!

 

 

@Ferran Chopo Garcia - thanks very much. I will feed this back to client.

 

I'm trying to migrate from Lotus Notes Databases which doesn't seem to have issue group by with 13000 items. It maybe legacy but still works on large data.

@John Seto - i am also finding this to be true with lists with only a couple hundred items. Grouped/expand/collapse does not appear to be ready for the modern UI. It's pretty frustrating. I've had lots of clients go back to folders for now so their users don't abandon SharePoint altogether.

@Kelly_Edinger 

I know I'm replying to a 2 year old thread, but I recently had this issue and after much struggling I got it working.

 

The solution was to change the filtering (not the grouping). Although I was already filtering by indexed columns, I had 4 criteria, with a mix of and and or logic, and used begins with for some items. Simplifying the filtering resolved the issue. I think it is because when loading ungrouped data it can load incrementally, and tolerate more complicated filters, but when grouping it must load all data at once and gets overwhelmed.

 

I switched to using And logic exclusively, and avoided begins with, and it's working now.