SOLVED
Home

Please Fix File Sorting by Name in Ms Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-779116%22%20slang%3D%22en-US%22%3EPlease%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779116%22%20slang%3D%22en-US%22%3E%3CP%3E10%20is%20a%20bigger%20number%20than%209%2C%20when%20sorting%20files%20by%20Name%2010%20should%20come%20after%209...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-779116%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Efix%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESorting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779840%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779840%22%20slang%3D%22en-US%22%3EThey%20won't%2C%20because%20file%20names%20are%20text%20fields%2C%20no%20where%20in%20history%20of%20data%20types%20does%20Text%20sort%2010%20in%20front%20of%209%20when%20the%20field%20is%20text%20%3A).%20I%20would%20say%20don't%20put%20numbers%20to%20sort%20your%20documents%2C%20but%20because%20Teams%20doesn't%20support%20metadata%20yet%20you%20can't%20really%20get%20around%20what%20you%20have.%3CBR%20%2F%3E%3CBR%20%2F%3ESoon%20as%20they%20release%20SharePoint%20file%20tab%2C%20you'll%20be%20able%20to%20setup%20a%20view%2C%20and%20if%20you%20have%20to%20have%20a%20pre-defined%20sort%20order%20you%20can%20add%20a%20weight%20or%20order%20column%20that%20is%20a%20number%20where%20you%20can%20then%20define%20order%20of%20items%20in%20your%20view.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779855%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779855%22%20slang%3D%22en-US%22%3EWhen%20is%20that%20SharePoint%20experience%20coming%20webb%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779860%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779860%22%20slang%3D%22en-US%22%3EI%20will%20cut%20you.%20%3CBR%20%2F%3E%3CBR%20%2F%3EP.S.%20(Supposedly%20Really%20Really%20Soon%20tm)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779861%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BI%20figured%20this%20was%20the%20case...%20on-par%20with%20with%20Microsoft's%20user%20experience%20across%20their%20multiple%20applications...%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3BSharepoint%20access%20is%20already%20available%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779872%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779872%22%20slang%3D%22en-US%22%3ENa%2C%20he%20and%20I%20were%20talking%20about%20the%20files%20tab%20in%20Teams%20(The%20default%20Files%20tab).%20Is%20going%20to%20use%20the%20SharePoint%20UI%20soon%2C%20where%20you%20can%20access%20column%20sorts%2C%20filters%20and%20views%20(Default%20views)%20to%20sort%20your%20files%20and%20access%20metadata.%20Right%20now%20it's%20not%20available.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779878%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779878%22%20slang%3D%22en-US%22%3EYeah%2C%20sorry!%20Inside%20jokes%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995288%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995288%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384320%22%20target%3D%22_blank%22%3E%40HYPERVELOCITY%3C%2FA%3E%26nbsp%3BThe%20sorting%20is%20character%20by%20character%2C%20so%20it%20compares%20%229%22%20to%20%221%22%2C%20not%20%2210%22%2C%20because%20the%20nine%20and%20the%20one%20are%20in%20the%20same%20position%20within%20the%20name.%20If%26nbsp%3Byou%20put%20a%20zero%20in%20front%20of%20the%20nine%2C%20such%20as%20%2209%22%20it%20will%20sort%20how%20you%20want%20because%20the%20zero%20will%20be%20compared%20to%20the%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%20of%20how%20the%20sorting%20works%3A%3C%2FP%3E%3CP%3EfileName01.txt%3C%2FP%3E%3CP%3EfileName05.txt%3CBR%20%2F%3EfileName07.txt%3CBR%20%2F%3EfileName09.txt%3C%2FP%3E%3CP%3EfileName1.txt%3CBR%20%2F%3EfileName10.txt%3C%2FP%3E%3CP%3EfileName27.txt%3C%2FP%3E%3CP%3EfileName3.txt%3C%2FP%3E%3CP%3EfileName50.txt%3CBR%20%2F%3EfileName8.txt%3CBR%20%2F%3EfileName9.txt%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20each%20additional%20digit%20in%20your%20number%20length%2C%20you%20would%20need%20to%20pad%20with%20another%20zero.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033581%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033581%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3BChris%2C%20any%20update%20on%20this%3F%3C%2FP%3E%3CP%3EI'd%20like%20to%20be%20able%20to%20sort%20by%20file%20name.%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033626%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033626%22%20slang%3D%22en-US%22%3EIt%E2%80%99s%20supposed%20to%20be%20rolling%20out.%20I%20haven%E2%80%99t%20seen%20it%20in%20any%20of%20my%20tenants%20yet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033629%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033629%22%20slang%3D%22en-US%22%3EThanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1064212%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Fix%20File%20Sorting%20by%20Name%20in%20Ms%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1064212%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20the%20correct%20number%20format%20for%20sorting%20%E2%80%A6%2001%3B%2002%3B%2003%3B%20%E2%80%A6%20%3B%2099%20%26nbsp%3B%26nbsp%3B%20or%20001%3B%20002%3B%20%E2%80%A6%20%3B%20999%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
HYPERVELOCITY
New Contributor

10 is a bigger number than 9, when sorting files by Name 10 should come after 9...

11 Replies
Highlighted
Solution
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.
Highlighted
When is that SharePoint experience coming webb??:white_heavy_check_mark:
Highlighted
I will cut you. :rolling_on_the_floor_laughing:

P.S. (Supposedly Really Really Soon tm)
Highlighted

@Chris Webb   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

Highlighted
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.
Highlighted
Yeah, sorry! Inside jokes :)
Highlighted

@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.txt

fileName1.txt
fileName10.txt

fileName27.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.

Highlighted

Hi @Chris Webb Chris, any update on this?

I'd like to be able to sort by file name.

Cheers.

Highlighted
It’s supposed to be rolling out. I haven’t seen it in any of my tenants yet.
Highlighted
Highlighted

Use the correct number format for sorting … 01; 02; 03; … ; 99    or 001; 002; … ; 999

Related Conversations
Modify Outlook invite links
arifC in Microsoft Teams on
4 Replies
Anyone else had Teams vanish from the apps list?
PhilC42 in Surface Hub on
1 Replies
Teams call transfer failed - Audiocodes VE
Olah Laszlo in Microsoft Teams on
0 Replies
Which headsets?
redtechguy in Microsoft Teams on
2 Replies