Welp, never saw this. Busy life and all - my apologies. Anyways I was never able to figure this out, so instead...
-----------
Basically I just made a search bar looking at one value, Employee Name, then used a filter for the other parameter, department.
- The page has a search bar and a drop down control at the top, then below is a gallery control.
- "Search bar" is named 'inpSearchBar' in Power Apps
- There is a Department dropdown. The Dropdown items are generated by using a collection, 'colDEPT', which is pulling the Department choices from the SharePoint list on app launch. I am using this in the Items property of the App Start to grab the department values to be used in the dropdown: ClearCollect(colDEPT,Choices('[SharePoint List]'.Department))
- "Items" property on the gallery below it:
SortByColumns(Filter('[SharePoint List]',StartsWith('Employee Name',inpSearchBar.Text),Department.Value=Dropdown1.Selected.Value),"Start Date",Ascending)
- It may not be exactly what is asked for in this but figured I'd tie this loose end. I got a thing about loose ends 🙂
If anybody ever has questions, please feel free to private message me.