Sort a combination of string and number

[_kikilalaaa]

Hi all. I have set my gallery items as follow:

Distinct(Filter('SPLIST',And('Name 1'= var1,'Name 2' = var2)),Level)

The gallery list should sort out like this:

L1

L2

L3

But, this came out instead:

L2

L3

L1

Anyone know how to fix it? Thank youu!

[RandyHayes · Accepted solution]

@_kikilalaaa 

Please consider changing your Formula to the following:

SortByColumns(
    Distinct(
        Filter('SPLIST', And('Name 1'= var1,'Name 2' = var2)),
        Level
    ),
    "Result"
)

I hope this is helpful for you. 

[_kikilalaaa]

Thank you! it works perfectly!