how to filter gallery by multi person?

(0) Share

Report

Posted on by beatlefreak

I have 2 lists.

First one contains users' information with column called "Class" and "User"

Class	User
A	Paul McCartney
B	John Lennon
C	Ringo
A	George Harr

Second one contains information of events that users are participating in,

Event	Participants
Event1	Paul McCartney, Ringo, Ronaldo, Ronaldinho
Event2	Beckham, John Lennon
Event3	Zidane

Now I have a dropdown of "Class" and want to filter the second Event gallery based on the User.

So, if I choose "A" in my Class dropdown, I want to see the items that Paul McCartney 'OR' George Harr (they are in Class A) is one of the participants of the event. This case it should be only 'Event1'.

I tried the code below

Filter(Event, Participants.Email in Distinct(Filter(UserInfo, Class = DropDown.Selected.Result), User.Email).Result)

Doesn't work..... any help?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 155,927 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @beatlefreak ,

Try this format

With( { wUser: AddColumns( Filter( UserInfo, Class = DropDown.Selected.Result ), "UserMail", User.Email ) }, Ungroup( ForAll( wUser As aUsers, Filter( Event, aUsers.UserMail in Participants.Email ) ), "Value" ) )

Note I have assumed some field names from your code (which is different to the image)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No