You’re offline. This is a read only version of the page.
Hello Everyone,
having an issue in filtering my gallery by 2 date picker,it was working correctly but after applying 24-hour to 12-hour conversion it filters the data but not as required.
when i select 13th in both datepicker it show no data.
formula used for filter:
gallery.item Filter('Training Request',Name.DisplayName=MyUser ,(PlanDate>=start_Date.SelectedDate)&&(PlanDate<=End_Date.SelectedDate))
For conversion followed https://powerusers.microsoft.com/t5/Building-Power-Apps/DatePicker-AM-PM/td-p/42766 this link
Data Source : Share point List
App: Canvas App
Best Regards,
Try this workaround:
If(End_Date.SelectedDate= start_Date.SelectedDate,
Filter('Training Request',Name.DisplayName=MyUser ,PlanDate>=start_Date.SelectedDate),
Filter('Training Request',Name.DisplayName=MyUser ,(PlanDate>=start_Date.SelectedDate)&&
(PlanDate<=End_Date.SelectedDate)))
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Share
Report
All responses (
Answers (
20,925
