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)

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,236)