Hello,
I need to sort on a people field that comes from SharePoint people column, also need to filter another two columns. Here is the code: this code brings back the whole list not people from New York and "Establishment" category. Thanks for your help!
If(
varSortColumn = "Employee",
SortByColumns(
Filter(
AddColumns(
GCChildSupport,
"PersonsName",
Employee.DisplayName
),
dplocation.Selected.Value = "New York" And varAction = "Establishment"
),
"PersonsName",
If(
SortDescending1,
Descending,
Ascending
)
)
