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.
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)
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.
Take a try with the formula below:
Filter(EventTable, DateTimeValue(2017QAAuditDate) = DateTimeValue(Text(Gallery1.Selected.DateColumn)))
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!