Calendar View

[KReyes]

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.

[v-micsh-msft]

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:

Filter function

Gallery usage

Regards,

Michael

[KReyes]

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.

[v-micsh-msft]

Hi @KReyes,

Take a try with the formula below:

Filter(EventTable, DateTimeValue(2017QAAuditDate) = DateTimeValue(Text(Gallery1.Selected.DateColumn)))

Function reference:

DateTimeValue()

Regards,

Michael