Answered

Sort order with Scandinavian characters

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to sort a menu in Power Apps were the source is a column in a SharePoint list. The columns holds words with Scandinavian characters like Å, Ä and Ö. When I use sort function in Power Apps, "Å" & "Ä" is treated as "A" and "Ö" is treated as "O" meaning that it is not sorted correctly.

They should be sorted last in alphabetical order, e.g. U, V, W, X, Y, Z, Å, Ä, Ö

Anyone who know how this could be solved? Is there any language formatting that I could use together with the sort function?

Regards

Patrik

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

My idea is to manually create a sort index,some thing like:

ClearCollect( SortIndex, {Value:"A",No:1}, {Value:"B",No:2}, {Value:"C",No:3}, {Value:"D",No:4}, {Value:"E",No:5}, {Value:"F",No:6}, {Value:"G",No:7}, {Value:"H",No:8}, {Value:"I",No:9}, {Value:"J",No:10}, {Value:"K",No:11}, {Value:"L",No:12}, {Value:"M",No:13}, {Value:"N",No:14}, {Value:"O",No:15}, {Value:"P",No:16}, {Value:"Q",No:17}, {Value:"R",No:18}, {Value:"S",No:19}, {Value:"T",No:20}, {Value:"U",No:21}, {Value:"V",No:22}, {Value:"W",No:23}, {Value:"X",No:24}, {Value:"Y",No:25}, {Value:"Z",No:26}, {Value:"Å",No:27}, {Value:"Ä",No:28}, {Value:"Ö",No:29} )

And then I assume there is a table :

Table({TheValue:"Ådhf"},{TheValue:"Bdfg"},{TheValue:"Ödfgh"})

Now,I can sort this table in this way:

Sort( Table({TheValue:"Ådhf"},{TheValue:"Bdfg"},{TheValue:"Ödfgh"}), LookUp( SortIndex, Value=First(Split(TheValue,"")).Result ).No )

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot Bof,

I've tried this on my setup but without any success, I forgot to mention that the source in sharepoint is choices, maybe that is why this doesn't work?

Current Menu setup is a Gallery:
Items= Sort(Choices("Name of the column in Sharepoint"),ThisRecord.Value,Ascending)

Label inside the gallery
Text = ThisItem.Value

Any other suggestion?

//Patrik
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Please try:

Sort( Choices(YourSPList.TheChoicesColumn), LookUp( SortIndex, Value=First(Split(Value,"")).Result ).No )

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot, that worked like a charm, appreciate all your help.

//Patrik
SteveLabbe 6 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-bofeng-msft ,
From what I see, it would only work to sort based on the first digit. What if I have the following strings:
Constructions Efficience
Constructions Éric
Constructions François
Would your proposition work? The result should be:
Constructions Efficience
Constructions François
Constructions Éric
If not, what do you suggest?
Thanks!