CRITICAL SHAREPOINT SORT FUNCTION ON A COLUMN WITH DATES NOT WORKING

Question

CRITICAL SHAREPOINT SORT FUNCTION ON A COLUMN WITH DATES NOT WORKING

Anonymous

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

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.

0 comments

Answer accepted by question author

Anonymous

Hi John,

Thanks for posting in the community. We are happy to help you.

A SharePoint list can have up to 30 million items, however, there is a known limitation for the list view threshold, which is 5000 items. I'm afraid that there is no way to change this limitation.

Regarding your questions, List above 5000 items is indeed possible with planning and some filtering/sorting compromises. Sorting such a list directly may cause problems or list view threshold errors. In this case, you can add Indexed columns to the list and set filters in the list view (click "Modify list view" and set filters to limit the number of items in the view to less than 5000). After that, you can sort items and place them in folders.

For your reference:

Living Large with Large Lists and Large Libraries

Create, change, or delete a view of a list or library

Manage large lists and libraries

Sorry for the inconvenience that happened to you. Appreciate your understanding and patience.

Sincerely,

George | Microsoft Community Moderator

0 comments

1 additional answer

Answer 1

Index all meaningful columns on that list.

The create a view filter by date “less than” put some date you expect to get leas than 5000 items.

Then you move the result items to your folder. Once you move all the files, change the view filter and start the process again.

I personally would use PowerShell to make this easier and move files to their respective folder based on the selected date.

Share via

CRITICAL SHAREPOINT SORT FUNCTION ON A COLUMN WITH DATES NOT WORKING

1 additional answer