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?
Solved! Go to 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")
Hi @sobenson ,
Please try below code
Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate)&& Location.Value="OnSite Rm 1")
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
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.
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
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.
Hi @sobenson
Does below code filters data properly ?
Filter('PackExpo Conf Schedule',Text(MeetingDate,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate))
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
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.
If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.
@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.
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")
User | Count |
---|---|
261 | |
110 | |
97 | |
53 | |
39 |