Modern grouped view not displaying results

%3CLINGO-SUB%20id%3D%22lingo-sub-1290842%22%20slang%3D%22en-US%22%3EModern%20grouped%20view%20not%20displaying%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1290842%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Modern%20library%20filtered%20and%20grouped%20view%20that%20displays%20%22Show%20All%22%20when%20the%20expanded%20group%20exceeds%2030%20items.%26nbsp%3BUpon%20clicking%20%22Show%20All%22%20or%20the%20group%20heading%20itself%20to%20view%20all%20items%20in%20that%20group%2C%20it%20does%20not%20display%20any%20results%2C%20however%20it%20works%20perfectly%20in%20Classic%20experience.%3C%2FP%3E%3CP%3EThe%20library%20has%20hundreds%20of%20document%20sets%20%E2%80%93%20one%20for%20each%20Job%20Request%20%E2%80%93%20so%20we%20have%20created%20a%20view%20that%20filters%20for%20Document%20Sets%20only%20and%20excludes%20several%20values%20of%20a%20Calculated%20Column%20(i.e.%20%22Job%20Status%22%20is%20not%20equal%20to...)%2C%20then%20group%20by%20the%20items%20by%20the%20same%20calculated%20column%20(%22Job%20Status%22).%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20appears%20to%20be%20grouping%20using%20THIS%20calculated%20column%20(contains%20IF%20statements)%20%E2%80%93%20the%20same%20view%20works%20when%20I%20select%20any%20non-calculated%20column%20or%20another%20concatenated%20calculated%20column%20to%20group%20by.%20When%20I%20re-introduce%20this%20particular%20calculated%20column%20for%20grouping%20(even%20at%20a%20second%20level)%20it%20fails%20to%20display%20results%20again%20but%20again%20will%20do%20so%20correctly%20in%20the%20Classic%20Experience!%3C%2FP%3E%3CP%3EPS%3A%20Also%2C%20is%20there%20some%20way%20to%20configure%20for%20more%20than%2030%20items%20before%20%22Show%20All%22%20appears%20(PS%3A%20I%20have%20increased%20the%20collapsed%20number%20of%20groups%20to%20display%20value%20but%20this%20doesn't%20affect%20Modern%20%22Show%20All%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1290842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eclassic%20experience%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGroupBy%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EModern%20Experience%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EViews%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

I have a Modern library filtered and grouped view that displays "Show All" when the expanded group exceeds 30 items. Upon clicking "Show All" or the group heading itself to view all items in that group, it does not display any results, however it works perfectly in Classic experience.

The library has hundreds of document sets – one for each Job Request – so we have created a view that filters for Document Sets only and excludes several values of a Calculated Column (i.e. "Job Status" is not equal to...), then group by the items by the same calculated column ("Job Status"). 

The problem appears to be grouping using THIS calculated column (contains IF statements) – the same view works when I select any non-calculated column or another concatenated calculated column to group by. When I re-introduce this particular calculated column for grouping (even at a second level) it fails to display results again but again will do so correctly in the Classic Experience!

PS: Also, is there some way to configure for more than 30 items before "Show All" appears (PS: I have increased the collapsed number of groups to display value but this doesn't affect Modern "Show All".

0 Replies