Forum Discussion
Please Fix File Sorting by Name in Ms Teams
10 is a bigger number than 9, when sorting files by Name 10 should come after 9...
- They won't, because file names are text fields, no where in history of data types does Text sort 10 in front of 9 when the field is text :). I would say don't put numbers to sort your documents, but because Teams doesn't support metadata yet you can't really get around what you have.
Soon as they release SharePoint file tab, you'll be able to setup a view, and if you have to have a pre-defined sort order you can add a weight or order column that is a number where you can then define order of items in your view.
11 Replies
HYPERVELOCITY The sorting is character by character, so it compares "9" to "1", not "10", because the nine and the one are in the same position within the name. If you put a zero in front of the nine, such as "09" it will sort how you want because the zero will be compared to the one.
Here is an example of how the sorting works:
fileName01.txt
fileName05.txt
fileName07.txt
fileName09.txtfileName1.txt
fileName10.txtfileName27.txt
fileName3.txt
fileName50.txt
fileName8.txt
fileName9.txt
For each additional digit in your number length, you would need to pad with another zero.- They won't, because file names are text fields, no where in history of data types does Text sort 10 in front of 9 when the field is text :). I would say don't put numbers to sort your documents, but because Teams doesn't support metadata yet you can't really get around what you have.
Soon as they release SharePoint file tab, you'll be able to setup a view, and if you have to have a pre-defined sort order you can add a weight or order column that is a number where you can then define order of items in your view.Use the correct number format for sorting … 01; 02; 03; … ; 99 or 001; 002; … ; 999
ChrisWebbTech I figured this was the case... on-par with with Microsoft's user experience across their multiple applications...
adam deltinger Sharepoint access is already available
- Na, he and I were talking about the files tab in Teams (The default Files tab). Is going to use the SharePoint UI soon, where you can access column sorts, filters and views (Default views) to sort your files and access metadata. Right now it's not available.
- When is that SharePoint experience coming webb??:white_heavy_check_mark:
- I will cut you. 🤣
P.S. (Supposedly Really Really Soon tm)
