SOLVED

SPO list view not showing filtered/grouped by items in Chrome/Edge

%3CLINGO-SUB%20id%3D%22lingo-sub-3293832%22%20slang%3D%22en-US%22%3ESPO%20list%20view%20not%20showing%20filtered%2Fgrouped%20by%20items%20in%20Chrome%2FEdge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293832%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20troubleshooting%20an%20issue%20in%20one%20of%20our%20long-time%20used%20SP%20list%20(around%203000%20items).%3C%2FP%3E%3CP%3EFor%20an%20unknown%20reason%2C%20the%20view%20(which%20is%20%3CSTRONG%3EF%3C%2FSTRONG%3E%3CSTRONG%3Eiltered%3C%2FSTRONG%3E%20by%20the%20people%2Fgroup%20type%20column%20using%20the%20%5BMe%5D%20and%20then%20%3CSTRONG%3EGrouped%20by%3C%2FSTRONG%3E%26nbsp%3Banother%20choice%20type%20column)%20stopped%20showing%20the%20items%20to%20our%20set%20of%20users%20who%20have%20been%20always%20using%20this%20list.%20The%20view%20is%20blank%2C%20even%20though%20there%20are%20items%20to%20show.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20has%20been%20troubleshot%20by%20MS%20Support%20already%20-%20the%20result%20was%20this%20is%20a%20browser%20issue.%3C%2FP%3E%3CP%3EHowever%2C%20I'm%20digging%20further%20and%20trying%20to%20find%20out%20what%20is%20going%20on%20and%20how%20to%20fix%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20able%20to%20reproduce%20the%20scenario%20with%20another%20list%20in%20another%20SP%20site%20collection.%3C%2FP%3E%3CP%3EI've%20not%20reinstalled%20Chrome%2FEdge%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario%3A%3C%2FP%3E%3CUL%3E%3CLI%3EIn%20Chrome%20or%20Edge%20or%20Opera%2C%20with%20my%20regular%20user%20test%20account%20(the%20same%20permissions%20granted)%2C%20I%20created%20a%20few%20test%20items%20in%20the%20list%20and%20navigated%20to%20the%20list%20view.%20Nothing%20to%20see.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jnhrv_3-1650885473445.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366537i37FB1C6EE947A4FE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jnhrv_3-1650885473445.png%22%20alt%3D%22jnhrv_3-1650885473445.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLI%3E%3CLI%3EWhile%20on%20the%20list%20view%2C%20I%20delete%20the%20cookies%20(%3CEM%3Esharepoint.com%3C%2FEM%3E%20and%20%3CEM%3Eourtenant.sharepoint.com%3C%2FEM%3E)%2C%20refresh%20the%20page%2C%20and%20can%20see%20the%20items%20now%2C%20filtered%20and%20grouped%20as%20expected.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jnhrv_1-1650885403669.png%22%20style%3D%22width%3A%20247px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366535iF741AB9DE2BE2CC4%2Fimage-dimensions%2F247x289%3Fv%3Dv2%22%20width%3D%22247%22%20height%3D%22289%22%20role%3D%22button%22%20title%3D%22jnhrv_1-1650885403669.png%22%20alt%3D%22jnhrv_1-1650885403669.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jnhrv_2-1650885439124.png%22%20style%3D%22width%3A%20593px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366536iFC0C4DD7AB1FE3FF%2Fimage-dimensions%2F593x147%3Fv%3Dv2%22%20width%3D%22593%22%20height%3D%22147%22%20role%3D%22button%22%20title%3D%22jnhrv_2-1650885439124.png%22%20alt%3D%22jnhrv_2-1650885439124.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLI%3E%3CLI%3EI%20refresh%20the%20page%20again%2C%20the%20items%20are%20not%20visible%20again.%3C%2FLI%3E%3CLI%3EIf%20I%20disable%20filtering%2C%20show%20all%20items%2C%20and%20use%20only%20Group%20By%20function%2C%20this%20works%20ok%2C%20no%20matter%20what%20browser.%3C%2FLI%3E%3CLI%3ETesting%20the%20same%20scenario%2C%20with%20the%20same%20Chrome%20build%2C%20with%20the%20same%20test%20account%20in%20a%20virtual%20machine%2C%20the%20issue%20does%20not%20occur%20and%20items%20are%20shown%20properly.%20No%20need%20to%20delete%20cookies%2C%20etc.%3C%2FLI%3E%3CLI%3EThis%20happens%20in%20the%20browser's%20incognito%20mode%20Guest%20mode%20or%20new%20profile%20as%20well.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20how%20to%20troubleshoot%20this%3F%20Would%20Fiddler%20help%20in%20this%20case%20and%20what%20to%20search%20for%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3293832%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301070%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20list%20view%20not%20showing%20filtered%2Fgrouped%20by%20items%20in%20Chrome%2FEdge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301070%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1376125%22%20target%3D%22_blank%22%3E%40gsreddin%3C%2FA%3E%26nbsp%3BHi%2C%20your%20workaround%20works%20really%20great%2C%20thank%20you%20for%20that!%20However%2C%20once%20I%20need%20to%20set%20the%20view%20to%20show%20the%20groups%20collapsed%20by%20default%2C%20I%20have%20to%20edit%20the%20view%2C%20save%20the%20view%20and%20then%20the%20view%20starts%20failing%20again%20and%20not%20showing%20any%20items%20when%20refreshed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20should%20be%20really%20addressed%20and%20fixed%20by%20MS.%20However%2C%20I'm%20tired%20of%20troubleshooting%20this%20for%20now%20and%20decided%20to%20live%20with%20your%20workaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3298817%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20list%20view%20not%20showing%20filtered%2Fgrouped%20by%20items%20in%20Chrome%2FEdge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3298817%22%20slang%3D%22en-US%22%3EI%20reported%20it%20to%20Microsoft%20this%20morning.%20But%20I%20may%20have%20found%20a%20workaround.%20Try%20this%20on%20your%20SPO%20and%20let%20me%20know%20if%20it%20works%20for%20you.%3CBR%20%2F%3E%3CBR%20%2F%3ECreate%20your%20view%20as%20normal%20but%20just%20put%20the%20%5BMe%5D%20filter%20on%20it.%20You%20should%20have%20results%20still.%20Now%20while%20viewing%20your%20results%20click%20on%20a%20column%20header%20dropdown%20and%20choose%20to%20Group%20By%20from%20there.%20On%20my%20end%20the%20results%20seem%20to%20stay.%20Then%20you%20can%20save%20the%20view%20as%20another%20view.%20For%20me%20this%20seems%20to%20work.%20I%20can%20even%20see%20the%20Group%20By%20clause%20when%20I%20edit%20the%20new%20view%20normally.%20It's%20strange.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3298457%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20list%20view%20not%20showing%20filtered%2Fgrouped%20by%20items%20in%20Chrome%2FEdge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3298457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1376125%22%20target%3D%22_blank%22%3E%40gsreddin%3C%2FA%3E%26nbsp%3BHave%20you%20reported%20this%20to%20MS%20Support%3F%20Any%20resolution%3F%3CBR%20%2F%3EI'm%20still%20confused%20about%20what%20the%20actual%20issue%20is%2C%20if%20a%20device%2C%20a%20browser%2C%20a%20cookie%2C%20the%20list%20filtering%2C%20and%20grouping%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3297843%22%20slang%3D%22en-US%22%3ERe%3A%20SPO%20list%20view%20not%20showing%20filtered%2Fgrouped%20by%20items%20in%20Chrome%2FEdge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3297843%22%20slang%3D%22en-US%22%3EI%20am%20having%20this%20same%20exact%20issue%20and%20came%20to%20this%20forum%20for%20a%20solution.%20I%20wasn't%20aware%20of%20the%20cookies%20and%20deleting%20the%20sharepoint.com%20cookies%20in%20Chrome%20does%20work%20until%20I%20refresh%20the%20view%20again.%20But%20in%20Edge%20it%20doesn't%20seem%20to%20work%20when%20deleting%20the%20cookies%20and%20refresh.%20Still%20blank.%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I'm troubleshooting an issue in one of our long-time used SP list (around 3000 items).

For an unknown reason, the view (which is Filtered by the people/group type column using the [Me] and then Grouped by another choice type column) stopped showing the items to our set of users who have been always using this list. The view is blank, even though there are items to show.

 

This has been troubleshot by MS Support already - the result was this is a browser issue.

However, I'm digging further and trying to find out what is going on and how to fix it.

 

I've been able to reproduce the scenario with another list in another SP site collection.

I've not reinstalled Chrome/Edge yet.

 

Scenario:

  • In Chrome or Edge or Opera, with my regular user test account (the same permissions granted), I created a few test items in the list and navigated to the list view. Nothing to see.jnhrv_3-1650885473445.png

     

  • While on the list view, I delete the cookies (sharepoint.com and ourtenant.sharepoint.com), refresh the page, and can see the items now, filtered and grouped as expected.jnhrv_1-1650885403669.pngjnhrv_2-1650885439124.png

     

  • I refresh the page again, the items are not visible again.
  • If I disable filtering, show all items, and use only Group By function, this works ok, no matter what browser.
  • Testing the same scenario, with the same Chrome build, with the same test account in a virtual machine, the issue does not occur and items are shown properly. No need to delete cookies, etc.
  • This happens in the browser's incognito mode Guest mode or new profile as well.

 

Does anyone have any idea how to troubleshoot this? Would Fiddler help in this case and what to search for?

 

Thank you.

4 Replies
I am having this same exact issue and came to this forum for a solution. I wasn't aware of the cookies and deleting the sharepoint.com cookies in Chrome does work until I refresh the view again. But in Edge it doesn't seem to work when deleting the cookies and refresh. Still blank.

@gsreddin Have you reported this to MS Support? Any resolution?
I'm still confused about what the actual issue is, if a device, a browser, a cookie, the list filtering, and grouping?

best response confirmed by jnhrv (New Contributor)
Solution
I reported it to Microsoft this morning. But I may have found a workaround. Try this on your SPO and let me know if it works for you.

Create your view as normal but just put the [Me] filter on it. You should have results still. Now while viewing your results click on a column header dropdown and choose to Group By from there. On my end the results seem to stay. Then you can save the view as another view. For me this seems to work. I can even see the Group By clause when I edit the new view normally. It's strange.

@gsreddin Hi, your workaround works really great, thank you for that! However, once I need to set the view to show the groups collapsed by default, I have to edit the view, save the view and then the view starts failing again and not showing any items when refreshed.

 

This should be really addressed and fixed by MS. However, I'm tired of troubleshooting this for now and decided to live with your workaround.