Forum Discussion
Can't see more than 30 items in list group
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 section
- JustinKobylarzJul 28, 2022Copper Contributor
I 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...
- HDDEV645Jul 29, 2022Copper Contributor
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!
- Badasha14333Sep 19, 2023Copper Contributor
This is a View Settings issue.
Top right click on 3 lines (switch view options).
Edit Current view
scroll to bottom to menu on left (Item Limit)
Click on Item Limit
Change Number of Items to display from 30 to whatever you need. Keep in mind the higher the number, the slower your list.
I had same issue, and it fixed it immediately. I hope this is helpful.