sort by columns

[Krishna_R]

Hi All,

I'm having a text column called version, like 1.0,2.0,3.0....10.0,11.0,12.0

I'm trying to apply sort by columns on this version column as shown below:

 "Version",
        SortByColumns(
            vFilterSort,
            "Version",
            If(
                vSort.vDir = Descending,
                Ascending,
                Descending
            )
        )

when i tried to sort on text column it is giving like 1.0,10.0,11.0,2.0

I've tried something like this 

 "Version",
        SortByColumns(
            vFilterSort,
            Value("Version"),
            If(
                vSort.vDir = Descending,
                Ascending,
                Descending
            )
        )

but no luck. any help / suggestions here ?

[Krishna_R]

I've founded workaround like this

"Version",
        SortByColumns(
            AddColumns(vFilterSort,"VerNum",Value(Version)),
            "VerNum",
            If(
                vSort.vDir = Descending,
                Ascending,
                Descending
            )
        )

hope there might be some better way as well

[timl · Accepted solution]

@Krishna_R 

The Sort function (rather than SortByColumns) would be another way to do this, which would avoid the need to call AddColumns:

Sort(
   vFilterSort,
   Value(Version),
   If(
      vSort.vDir = Descending,
      Ascending,
      Descending
   )
)