How to sort by columns twice?

[ianallen13V2]

Hello, 

I have a drop down that is connected to a SP library to pull the colleagues in our department.  I have to sort by columns in order to get it to sort alphabetically, but I also have a 'team' column, is there a way to get it to sort alphabetically and also by that specific team?  Here is the current formula: 

Specialist List is my SP list and "Specialist" is the name column.  I want to also have it so only colleagues under a certain team are visible instead of all colleagues.  How can I do this?

[sgtsnacks · Accepted solution]

Hi ianallen13V2,

You can add multiple criteria to the SortByColumns function, as follows:

SortByColumns('Data Source',"Column Name",Ascending,"Column Name 2",Descending)

If you then want to filter out certain Teams, you could wrap the entire function in a Filter statement:

//Filter Then Sort
Filter(SortByColumns('Data Source',"Column Name",Ascending,"Column Name 2",Descending),Not("TeamName" in Team))

//Sort Then Filter
SortByColumns(Filter('Data Source',Not("TeamName" in Team)),"Column Name",Ascending,"Column Name 2",Descending)

[StalinPonnusamy]

Hi @ianallen13V2 

To filter the list, Do you have a separate SP list for teams and all members on that team? So that we can filter the list?

[ianallen13V2]

Greatly appreciate the response - for some reason when I try to add in the 'teams' column, it continues to say: "There is an error in this formula.  Try revising and running it again.  Data type: text" - this column is the same as all the others, there is no differentiation.  

Any thoughts?

[StalinPonnusamy]

Hi @ianallen13V2 

Please try this

SortByColumns(
    With(
        {Item: [@'Specialist List']},
        Filter(
            Item,
            Team <> "Evaluations Team"
        )
    ),
    "Specialist",
    Ascending,
    "Team",
    Descending
)

Thanks,
Stalin - Learn To Illuminate

[ianallen13V2]

So sorry - disregard this.  I got it figured out.  Thank you again so much for the answer!