Unanswered

Filter based on a Table Person Field present in a Collection with a Person field

(0) Share

Report

Posted on by abilsborough

I have a table "PA Weekly Activities" with a Person field (no multiple selections) called Surveyor. I also have a collection colMembers with a Person field called TeamMember (no multiple selections). I'd like a Gallery filtered on the table field Surveyor being in the collection based on the field TeamMember.

The 2 fields are exactly the same apart from the names, I can view the collection and see the Email of TeamMember. So, I can output the TeamMember Email address but it's the reference to a property of TeamMember within a filter that seems to be the sticking point.

The basic filter is:

Filter(
'PA Weekly Activities',
XXXXXXXXXXXXXXXX
)

The following lines replacing XXXXXXXXXXXXXXXX don't work for reasons of comparing Text to Record, missing TeamMember etc.

Surveyor in colMembers.TeamMember

Surveyor.Email = colMembers.TeamMember.Email

Surveyor in colMembers[@TeamMember]

Surveyor.Email = colMembers[@TeamMember].Email

I've tried dozens of alternatives but ran out of ideas. Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @abilsborough

The "in" function will work, but can only look at a single column. You can use ShowColumns to get it to work:

Filter('PA Weekly Activities',Email in ShowColumns(TeamMember,"Email"))

Here's an example:

Was this reply helpful? Yes No
abilsborough 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the prompt reply and example, that feels the right way to do it but still having problems referring to the Email property of TeamMember. The errors saying column Email doesn't exist. I've tried:

Filter('PA Weekly Activities',Surveyor.Email in ShowColumns(TeamMember,"Email"))
Filter('PA Weekly Activities',Surveyor.Email in ShowColumns(colMembers,"TeamMember.Email"))
Filter('PA Weekly Activities',Surveyor.Email in ShowColumns(colMembers[@TeamMember],"Email")

TIA.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abilsborough

I'm sorry, I forgot that your column TeamMember is a People Picker and is returning a table of the person attributes. Can you collect only the email for your colMembers in a separate collection and then use that for reference?

Was this reply helpful? Yes No
abilsborough 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Yes that's the reason I tried a collection as I couldn't find a Filter option that worked. I thought I'd create a simple collection of emails but I'm having the same problems whether it's extracting email addresses to a collection or a filter statement. I probably should go back to a normal filter, it's all I need.

BTW I can output an email from the collection as below, it just seems to be a problem with the Filter statement.

TIA.

Was this reply helpful? Yes No