Hello i am trying to do a filter on a galley from my a SharePoint list to only show items that are part of their department which does work but also want to give them an option in a drop down to sort some more depending on the status of the items they see.
this is my Department Sort
SortByColumns(Filter(ServiceRequest,Department=Office365Users.MyProfile().Department),"{Identifier}",Ascending)

this is the gallery and want the select box which is getting the status from my SharePoint list to filter the items i see.