Filter SharePoint list date column using date picker

[Narula_Srinivas]

Hi Friends......I am trying to build an app with sharepoint list as datasource with some one filter. I have gone through most of the posts in this forum and tried below queries but no luck in getting right results.

Data Source Name : 'Session Booking'

SharePoint List Date Column name : SessionStartDate

Filter('Session Booking', SessionStartDate>=Today())

Filter('Session Booking', SessionStartDate>=DatePicker2.SelectedDate)

Filter('Session Booking', SessionStartDate>=Text(DatePicker1.SelectedDate, "[$-en-US]dd/mm/yyyy"))

SortByColumns(Filter('Session Booking', SessionStartDate>=Today()),"SessionStartDate",If(SortDescending1, Descending, Ascending))

Need your help in finding right formula to get results.

Advance Thanks!!

[Narula_Srinivas · Accepted solution]

After spending more than a day...I could able to filter sharepoint list date column with powerapp datepicker.

Instead of passing DatePicker2.SelectedDate directly to sharepoint date column. We need to pass Year,Month & Day seperately as shown below.

ActivityStartDate<=Date(Year(DatePicker2.SelectedDate),Month(DatePicker2.SelectedDate),Day(DatePicker2.SelectedDate))

Hope this helps someone.

Happy Coding!!

[YatinP]

Thanks but did not work for me. Is is specific to Region?

[Narula_Srinivas]

not sure. I am using UK region.