web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering through 'mul...

Power Apps

Answered

Filtering through 'multiple select' columns

(0) Share

Report

Report

Posted on by han080

Hi everyone!

I'm trying to build an app based on a sharepoint list of projects.

Some projects are assigned to multiple people (you can just select multiple people in the "assigned to" column).

I'm trying to create a screen on an app called 'my projects', however I'm having issues with filtering the gallery through the 'assigned to' column based on the 'User().FullName' as the column now contains a table for each record.

If anyone could help me out I would really appreciate it!!!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@han080
Filtering should be done on a unique identifier. Two people can have the same name (e.g. John Smith). Therefore, I recommend you Filter based on the user email.

The IN operator can be used to check if a value exists in a set of records.

Filter( 'Your SharePoint List', User().Email in 'Assigned To'.Email )

---
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

Join the conversation