Forum Discussion
Can't see more than 30 items in list group
In SharePoint Online, if I group a list it shows only 30 items in the group regardless of how big I make the item limit on the view. I see a "Show all" link below the first 30 items, but when I click it I still see just those 30 items. I saw something about this on an old Microsoft site that seemed to indicate this was a bug. But that discussion was in 2019, so I figured sure they had fixed it by now.
Is this a bug? If so, is there a workaround? Or am I just missing something.
8 Replies
- I have the same issue.. its extremely frustrating. I am working on an energy industry industry wide Programnme mainly focused on reviewing 100s of documents. I am not in a position to educate over 600 participants on the quirks of SharePoint. At least clastic SP had pagination. Creating a new bespoke view based on arbitrary information isnt really gong to work.
My issues is that regardless of settings it stops at 30 if the user scrolls down too fast , it just gives up - This is by design I feel, you will not get a "fix" for it anytime soon.
Options that I see are - a custom SPFx webpart where you can perform your own batched REST Api queries, or have a seperate webpart for each "group" and use the accordian sectionI just changed it from a group to be sorted from A to Z, which in my case works fine. Actually I prefer it because there is less unutilized space.
Although it *Seems* like it is user customizable due to the Item Limit threshold. What does that value DO if it does not control the items in a group? Suspicious that it is also set at 30 as a default...
Hello,
I found the solution :
So far changing the List Settings - > Advanced Settings -> Set Offline Client Availability to 'No' seems to work.
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-caching-problems-with-lists/m-p/3061137...
The OneDrive client appears to be syncing Lists from SharePoint Online (et. al) by default. To verify this is what is happening, you can perform the following steps:
Open Dev Tools on Chrome (F12)
Navigate to "Network"
Select "Fetch/XHR" as type
Enter "RenderListDataAsStream" as a filter
Attempt to sort a list that is cached
The results should show "localhost", "::1", or an equivalent loopback address under the "Remote Address" column.
You can then use resmon, netstat or Get-NetTCPConnection/Get-Process to find the IM of the process name and ID of the port being used for these local XHR requests to the RenderListDataAsStream endpoint. In my scenario, it was port 42050 (probably randomized), which was shown in use by the Microsoft.SharePoint.exe application, located under \AppData\Local\Microsoft\OneDrive\<version number>.
If you see this behavior, you can attempt to mitigate the caching by:
Setting
[HKLM\SOFTWARE\Policies\Microsoft\OneDrive] "DisableNucleusSync" = "dword:1"
(per MS Docs - Use Group Policy to control Lists sync settings )
Rebooting machine, or force closing the task with IM of "Microsoft.SharePoint.exe".
Reloading the list page (may need to force-refresh).
This appears to be working on our test machines (all Modern UI queries are forced to use the SPO servers instead of OD), but I'm not entirely sure of the effect this setting could have in regards to SP, OneDrive, Teams, etc - so it should probably be used with caution.
Hopefully this helps your tenants as well. Good luck!
- Having the same issue here with the 30 item limit... Although my "Show all" link is working perfectly.
But my problem is that it limits all group by items to a maximum of 30 per grouped value. Even if I change the paging limit or set the view to just query 1000 items in total. It does fetch the data in the back-end I checked the RenderListDataAsStream api call. But it just doesn't want to show more than 30... Has this changed or was this always like this? Can't remember the "Show all" link for group by views in modern experience in the past. In classic experience the group by and paging limits are working fine and as expected.- hello, I have exactly the same problem as you, with my client it is impossible to display more than 30 elements from a group. but with me no worries, have you tried to launch your list in private browsing?
what happens when you limit the display to 10 items?
