Power Platform Community Forum Thread Details

Hi Experts,

I have a gallery that is acting as a calendar and I have the below in the Items property

ForAll(
 Sequence(42),
 {Value: varFirstDayOfMonth + Value - 1 - Weekday(
 varFirstDayOfMonth,
 StartOfWeek.Sunday
 ) + 1,
 NextDay: varFirstDayOfMonth + Value - 1 - Weekday(
 varFirstDayOfMonth,
 StartOfWeek.Sunday
 ) + 2}
)

I have a dropdown box named drpInstallersList which is a sharepoint Choices item and it's Items property is below

Choices([@Installations].Installers)

I want to be able to filter the calendar gallery using the dropdown box. The default option in the dropdown list is "Please select an Installer", I want to exclude that option from the filter so that if that dropdown displays that text then it should show all results in the calendar gallery but if the user selects an option from within the dropdown then it should only show that installers jobs in the calendar. For example sake, say the dropdown choices are Dave, John, Steve, Pete.

Hopefully that all makes sense

Thanks in advance!

Categories:

Building Power Apps