Answered

Filter a gallery from ClearCollect and Dropdown selection

(0) Share

Report

Posted on by scottypotty4x4

I am creating a custom event calendar. I use a connected SP list that contains the event start/end dates and a selectable column for who is to perform the event. I utilize ClearCollect (colEvents) to gather all the events and place them in a child gallery but need to add a filter feature that allows me to only show a specific person's event. My gallery displays the events using the following Filter:

Filter(colEvents, StartDate <= DateValue(lblCurrentDate.Text) And EndDate >= DateValue(lblCurrentDate.Text))

The dropdown items are as follows:

Choices('ConsultantActivity'.'Consultant')

How do I also incorporate the dropdown selection to the filter to display the events related to the individual selected?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@scottypotty4x4

If your Consultant column is a Person column, then your formula would be this:

Filter(colEvents, StartDate <= DateValue(lblCurrentDate.Text) && EndDate >= DateValue(lblCurrentDate.Text) && Consultant.Email = yourDropdown.Selected.Email )

If it is something other than a person column, then please adjust as necessary or post back with more details on it.

I hope this is helpful for you.
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @scottypotty4x4 ,

In the below code replace "yourDropdown" with the control name of your dropdown...
Can you try the following code inside the items property of your gallery
Filter(colEvents, (StartDate <= DateValue(lblCurrentDate.Text) And EndDate >= DateValue(lblCurrentDate.Text)),(Len(yourDropdown.Selected.Value)=0 || 'Consultant'.Value in yourDropdown.Selected.Value))