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!!
Solved! Go to 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!!
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!!
Thanks but did not work for me. Is is specific to Region?
not sure. I am using UK region.
User | Count |
---|---|
252 | |
101 | |
94 | |
47 | |
38 |