cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiteshGovan
Post Patron
Post Patron

Date picker and sort by ascending is not working

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)

1 ACCEPTED SOLUTION

Accepted Solutions
CNT
Super User
Super User

@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)

View solution in original post

4 REPLIES 4
CNT
Super User
Super User

@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
Super User
Super User

@MiteshGovan Did it work? If so,

 

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

Hi

 

Thank you. It did. 

@MiteshGovan Glad to help! Have a great day!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,914)