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?
Solved! Go to 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)
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)
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?
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?
Please try this
SortByColumns(
With(
{Item: [@'Specialist List']},
Filter(
Item,
Team <> "Evaluations Team"
)
),
"Specialist",
Ascending,
"Team",
Descending
)
Thanks,
Stalin - Learn To Illuminate
So sorry - disregard this. I got it figured out. Thank you again so much for the answer!
User | Count |
---|---|
167 | |
96 | |
77 | |
72 | |
59 |
User | Count |
---|---|
210 | |
166 | |
97 | |
94 | |
78 |