Forum Discussion

PerA's avatar
PerA
Occasional Reader
Sep 19, 2025

Sorting a SharePoint List alphabetically it Swedish

Hi!

 

I'm working on a ShrePoint site for my organisation and have run into an issue with a SharePoint list. The entire site is in Swedish and I've run inte issues when Grouping/Sorting. 

 

In the list i have a column (lets call it "Letter") that uses a formula 

=LEFT(Title)

to extract the first letter from the Title of each list item for the purpose of being able to group by letter. So the list is first grouped by "Letter" and the Sorted alphabetically by "Title".

The issue is how SharePoint handles "alphabetical order" of the Swedish alphabet. The Swedish alphabet is the same as English, but with 3 additional letters, "Å", "Ä" and "Ö". While they could be considered A's and O's with diacritics, in Swedish they are considered their own letters. And alphabetically they come after Z.

I want my list sorted "A, B, C, ... X, Y, Z, Å, Ä, Ö", but SharePoint sometimes sorts it "A, Ä, Å, B, ... N, O, Ö, P, Q, ..., X, Y, Z"

The strange thing, however, is that this problem only arises when i load the list on a SharePoint page as a Web part. 

 

 

So in short: Problem only occurs when grouping or sorting the column "Letter", and i only occurs when using the list in a web part.

 

Has anyone run into anything similar? I've looked thourgh all the setting i can access for both the site and the list. All Language settings are set to Swedish as well. 

No RepliesBe the first to reply

Resources