Power Apps- Order your Dropdown options for Distinct Text Sharepoint list Column Values

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)

Blog Type: