sortinglookuppowerapps-canvas

Powerapps sort combobox first item will be todays date

i have managed to populate a combobox in PowerApps with multiple column items i would like to have the first item (Date_by_Day) = today i have played around with Sort(),Ascending, Date_by_Day = Today() but no luck

Distinct(RP_Weekly_Period_Dates_SPList,Date_by_Day & " : " & 'Week 
(Long)' & " - " & 'Period (Long)' & " - " & Year)

Not sure if this possible but any suggestions would be great

Solution

  • datepicker is the best way with error message if any other day is selected