Unanswered

Filter Multi-PeoplePicker

(0) Share

Report

Posted on by CU20080325-0

Hello,

I am trying to display dropdown values by filtering a SharePoint list that contains a people picker "Assigner" that could have more than 2 people. I am checking if the current user logged in is within the "Assignee" people picker. If it is, then I need to display the title of the record.

For example (IF you are "Bob"):

Title	Assignee	Manager
Project A	Bob, Matt, Joe	Mary
Project B	Bob, Joe	Diego
Project C	Antonio	Mary

My dropdown should only display Project A and Project B since "Bob" is assigned as one of the "Assignees".

The tricky part about this is that the "Assignee" column gets returned as a table and when you wrap around the filter it doesn't work as expected.

so far I've tried many methods but these have been the closest to the solution:

Filter(Projects,!IsEmpty(Filter(Assignees.Email,Email= User().Email))).Title

Filter(Projects,LookUp(Assignees, Email = User().Email,Email) = User().Email).Title

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Andres-san

Consider trying this formula to see if you get closer:

Filter(Projects, User().Email in Assignees.Email)

Should give you what you need.

I hope this is helpful for you.

Was this reply helpful? Yes No
CU20080325-0 9 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes,

Thanks! This works if I compare it against a string type but not the people picker table.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Andres-san ,

Use below code for your issue.

hope this will help you to resolve your issue.

Filter(AddColumns(TestAkshay,"AllAssignedEmail",Concat(Candidate,Email,";")),Lower(User().Email) in AllAssignedEmail)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Andres-san

I'm not sure what you mean by the people picker table.

You mentioned that the Assignees is a multi-selectable person column in your SharePoint list.

So, using the data example you provided, this formula should return Project A and Project B if the user is Bob

Filter(Projects, User().Email in Assignees.Email)

Was this reply helpful? Yes No