web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering through 'mul...
Power Apps
Answered

Filtering through 'multiple select' columns

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • Verified answer
    mdevaney Profile Picture
    29,991 Moderator on at

    @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."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard