What's the best way to combine these two expression if I want to Sort and Filter?
DropColumns(
SortByColumns(
AddColumns(
Test,
"departmentName", Department.Name,"facilityName", 'Facility'.Name
),
varSort,
If(blnSortDescending1,Descending,Ascending) //or descending
),
"departmentName","facilityName"
);
DropColumns(
Filter(
AddColumns(Test,
"facilityName", Facility.Name
),
//your criteria
StartsWith(facilityName,txtDeptFilter.text)
),
"facilityName"
)
