SortColumn not working on Lookup

[saturation]

I'm trying to set SortColumn on a lookup column on my gallery item. State is the name of the lookup entity.

Set(SortColumn, "State");UpdateContext({SortColumn: "State", SortDescending: !SortDescending})

I've also tried State.Value, State.Name etc (in double quotes)

My sorting works on text fields using the same syntax. Can someone help here? 

[v-xida-msft · Accepted solution]

Hi @saturation ,

Have you taken a try with the solution I provided above?

Currently, within PowerApps, you could not specify Complex type column (e.g. LookUp, Choice, ... etc) as Sort column within the SortByColumns function.

As an alternative solution, I think the Sort function could achieve your needs. In addition, you could not specify variable as Sort column within the Sort function.

Please consider take a try with above Sort function I provided, then check if the issue is solved:

Sort(
     Filter(
             'MyData',
             ....
     ),
     If(                                // choose different Sort formula based on the SortField variable value
        SortField = "State",
        State.'Primary Name',            // 'Primary Column' represents the child property under the State LookUp field
        SortField = "Column1",
        Column1,
        ....
     )
     ,
     If(
         SortDescending,
         SortOrder.Ascending,
         SortOrder.Descending
      )
)

Best regards,