This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a list that has a filter on it to reduce the items in the list. For some reason the sorting of columns doesn't work correctly. Within the same sharepoint list in a different view the sorting on the same columns works fine. I have gone through the settings of the view and changed it multiple times. Additionally, instead of items populating upon opening the list it makes me click the "load more items" button. Any tips and tricks would be appreciated.
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 78%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
It's not the number of items in a view, it's the number in the list. This is a hard limit Msft likes to downplay but If you go over 5k, most operations will fail.
Hi Sophia, thank you for the reply!
1. There are only two items in the view I have questions about, so not near 5000. Additionally, the view doesn't load - it forces me to click "Load more items".
The main issue I see is that the view is not sorting on columns. I have attached screenshots of the view "My Open PM Cases" that doesn't sort that is only 2 items, and included the settings of the view. Additionally, I included a similar view that is much larger that does sort by column and works appropriately. I have included screenshots of the view and the settings.
View that cannot sort:
View that can be sorted:
This situation is faced by all users.
Hi,
Good day!
To better understand your situation and help narrow down this issue, could you provide the information or screenshot below?
1, Could you please help check and confirm if it is around 5000 items in the view(for example, 4800-5000)? If yes, it's normal behavior in SharePoint online.
2, The screenshot of the situation you faced,
3, Does all users have this behavior?
Have a nice day.
Best regards,
Sophia