How can I filter a second gallery to show the events on the selected day? I have a calendar view gallery set up and I would like to pick a day and show the events for that date in a separate gallery.
Hi @KReyes,
Would you please share a screenshot of how you set up the Calendar View Gallery?
Mostly we could get the selected result by using Gallery.Selected.FieldName,
Assuming you have an Event table a date column within it, then under the items property of the second gallery, the formula should be:
Filter(EventTable, Date = Gallery1.Selected.DateColumn)
Function reference:
Regards,
Michael
I tried using the suggested formula and it seems that it does not recognize Date? I also tried Filter(Schedule,'2017QAAuditDate' = CalendarView.Selected.Value) and it doesnt show any error, but it does not return any value. I have a table named Schedule with a column named 2017QAAuditDate. I also tried with a weekly calendar view and it does not work either. Any help is greatly appreciated.
Hi @KReyes,
Take a try with the formula below:
Filter(EventTable, DateTimeValue(2017QAAuditDate) = DateTimeValue(Text(Gallery1.Selected.DateColumn)))
Function reference:
Regards,
Michael
User | Count |
---|---|
252 | |
106 | |
88 | |
51 | |
44 |