CRITICAL SHAREPOINT SORT FUNCTION ON A COLUMN WITH DATES NOT WORKING

Question

Hello

Please i need your help on the same issue.

 I NEED help TO SORT THROUGH 28K items on a site by Date and place them in folders of 5k each.

How do i start on this task to maintain SharePoint site in that way

• i was shocked that Microsoft ALLOWS 50K ITEMS BUT WORKS WITH ONLY 5K. I wonder why THE OTHER 45K WHEN THE COLUMN SORT FUNCTIONS OR FILTER DO NOT WORK.
• I have tried this in the Modern View. 30M items is SharePoint limit but cannot sort 28k items is alarming if so- how does one resolve this.

I have all the files in this site and if i cannot sort them on the site using columns then how else can i do it .

 

There is a column with Dates and SharePoint does not sort them from Older to New or New to Old when the column is clicked- no filter option can do the job either

 

Answer 1

Hi @IniobongNkanga-8038 ,

The reason why SharePoint only works with 5K items is due to the list view threshold limit of 5,000 items for a view. If the list or library exceeds this limit, you will receive an error message when you try to sort or filter a column in the view. To resolve this issue, reduce the number of items in the view for the affected list or library to 5,000 items or less.

As a workaround, you can selete ALL of the items in the library (send them to the recycle bin).  Then you can turn on the Indexes, and then restore the deleted items from the recycle bin.

Reference:https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-online-index-column-5-000-limit/m-p/14065#M1227

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.