Power Apps- Order your Dropdown options for Distinct Date Values and format date for Power Apps Sharepoint list Date Column

Power Apps- Order your Dropdown options for Distinct Date Values and format date for Power Apps from a Sharepoint list Date Column

In your Combobox or dropdown "Items" property:

Sort(

    ForAll(

        Distinct(

            YourSharepointList,

            YourDateColumn

        ),

        {

            DateSort: Text(

                Value,

                "yyyymmdd" //For an accurate Sort

            ),

            DateDisplay: Text(

                Value,

                "mm/dd/yyyy" //For proper display format

            )

        }

    ),

    DateSort,

    SortOrder.Ascending

)

In your gallery in the "Items" property:

Filter(YourSharepointList, YourDateColumn = ComboBox2.Selected.DateDisplay)