I added a Dropdown list that filters a gallery by Manager Name.
Using distinct Manager Names as option for my drop down were is a crazy order.
I want the options on the dropdown to be alphabetical so Managers are easier to find and select.
Here is the cheater code for the Items property of your dropdown:
Sort(Distinct('Your Sharepoint List', ColumnName),Value,SortOrder.Ascending)
And in your Gallery "Items" property:
Filter('Your Sharepoint List', ColumnName = Dropdown.Selected.Value)