Filter SP List date/time column, choice column and datepicker

[sobenson]

I am stuck.  I have a Confeence Room Schedule list, and am trying to create an app to display the schedule for multiple days.  If my SP list MeetingDate field is just a date field, this works filtering the gallery to show that date and room

Filter(
     'PackExpo Conf Schedule',
           MeetingDate=DatePicker1.SelectedDate,   
           Location.Value="OnSite Rm 2"
         ) 

If I change the MeetingDate column to include time, my filters work independent, but not together

Shows correct room

Filter('PackExpo Conf Schedule',Location.Value="OnSite Rm 1" )

If I change it to this, (with my MeetingDate having both date and time) I get it to work with the datepicker

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate))

but together nothing is showing

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate), Location.Value="OnSite Rm 1")

I also tried and get the same blank results (Thanks for trying @PG_WorXz10 )

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate)&& Location.Value="OnSite Rm 1")

What  am I doing wrong?

[PG_WorXz10]

Hi @sobenson ,

Please  try below code 

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate)&& Location.Value="OnSite Rm 1")

[sobenson]

@PG_WorXz10 That did not work either.  It clears all data from the gallery

[PG_WorXz10]

Hi @sobenson ,

Just to be sure that filters are working and there is not issue with the data. Could you please try below code ? 

If it works the issue is with the data in the List but if it does not show anything we can be sure that there is some issue with the filters. 

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate) || Location.Value="OnSite Rm 1")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sobenson]

Yes @PG_WorXz10  that does show information.  This is all stemmed from adding the Time option with the Date/Time column.  Even though I am saying pull out the "ShortDate" it won't filter.  Either one of the filters work separately, but not together.

[PG_WorXz10]

Hi @sobenson 

Does below code filters data properly ?

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate))

[sobenson]

@PG_WorXz10  Yes it shows everything for the selected day

[PG_WorXz10]

Hi @sobenson ,

Just to confirm there is no issue with  list data could you test manually by filtering the backend with DatePickerSelectedDate and Location value Onsite Rm 1. 

[sobenson]

@PG_WorXz10 I am not 100% sure what you are asking, the back end is a SP List.  Both of these filters work independent.

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate))

Filter('PackExpo Conf Schedule', Location.Value="Onsite Rm 1")

Attached is an excel export of my list.  I was trying to play around with calculated columns to see if I could get it to work with that, but am having similar issues.

[sobenson · Accepted solution]

I resolved the issue the DatePicker does not need to have "Shortdate" added.  

Below is the working code

Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate)=Text(DatePicker1.SelectedDate) && Location.Value="Onsite Rm 1")