Answered

Sort order with Scandinavian characters

Like (0) Share

Report

Posted on 17 Sep 2021 14:47:21 by Community Power Pla...

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:

General Questions

I have the same question (0)

All responses (5)

Answers (1)

SteveLabbe 6 on 26 Apr 2023 at 19:13:19

Like (0)

Report
Re: Sort order with Scandinavian characters

@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!

Was this reply helpful? Yes No
Community Power Pla... on 24 Sep 2021 at 06:09:39

Like (0)

Report

Re: Sort order with Scandinavian characters

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

//Patrik

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on 24 Sep 2021 at 02:01:37

Like (0)

Report
Re: Sort order with Scandinavian characters

Hi @Anonymous :

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on 23 Sep 2021 at 14:53:11

Like (0)

Report

Re: Sort order with Scandinavian characters

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

Was this reply helpful? Yes No
v-bofeng-msft on 20 Sep 2021 at 03:54:10

Like (0)

Report
Re: Sort order with Scandinavian characters

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

Was this reply helpful? Yes No