Answered

PowerApps Default Sorting with Values

(0) Share

Report

Posted on by MartySt

Hello,

I have a set of data that is sorted by a column called DataOrder. It is numbered from 1 through 12, see table below for example. The Issue I'm having is that powerapps does not sort it in the way I would expect, from 1 to 12 in order, it actually sorts like this:

1,10,11,12,2,3,4,5,6,7,8,9

This is incredibly annoying, since I specifically put in a column called DataOrder to order my data in the way you would expect...

It works the way you would expect for a data set less than 10, since it counts from 1 to 9 and then that's it.

Here is my code for reference: Sort(Table1,DataOrder,SortOrder.Ascending)

Does anyone know how I can fix this?

DataOrder

1
2
3
4
5
6
7
8
9
10
11
12

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Pstork1 69,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
The problem is that your DataOrder column is a string data type and not an integer. So the column is sorting alphabetically rather than numerically. Change the Data type on the column and it should work correctly. If the list isn't a large one you should also be able to try this formula. But it won't be delegable.

Sort(Table1,Value(DataOrder),SortOrder.Ascending)

Was this reply helpful? Yes No
MartySt 33 on at

Like (0)

Report
Copy link

Link copied!

This worked!

Thanks so much.

Was this reply helpful? Yes No