Date picker and sort by ascending is not working

[MiteshGovan]

Hi

I trust that you are well. my datepicker and sort by ascending is not working. Could you please advise why?

Filter('Ascendis Medical',StartsWith(Title,TextSearchBox1.Text),IsBlank(ComboBox3.SelectedItems.Result)||IsEmpty(ComboBox3.SelectedItems.Result)||Department= ComboBox3.Selected.Result || Status=ComboBox3_1.Selected.Result||Check_In_Time= DatePicker1.SelectedDate)

[CNT · Accepted solution]

@MiteshGovan You'll have to a SortByColumns like this,

SortByColumns(Filter(
  'Ascendis Medical', 
  StartsWith(Title, TextSearchBox1.Text), 
  IsBlank(ComboBox3.SelectedItems.Result)|| IsEmpty(ComboBox3.SelectedItems.Result)|| Department = ComboBox3.Selected.Result || Status = ComboBox3_1.Selected.Result || Check_In_Time = DatePicker1.SelectedDate
), "Check_In_Time", Ascending)

[CNT]

@MiteshGovan Did it work? If so,

Please remember to give a 👍 and accept the solution as it will help others in the future.

[MiteshGovan]

Hi

Thank you. It did. 

[CNT]

@MiteshGovan Glad to help! Have a great day!