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 / Adding Additional Filt...
Power Apps
Suggested Answer

Adding Additional Filter Criteria to Microsoft Entra IDs Formula

(0) ShareShare
ReportReport
Posted on by 129
Hi all,
 
I need some assistance with a formula I'm using in my Items property to filter a list of persons in my Microsoft Entra IDs. The current formula is as follows:
Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member")
This formula filters the list to show only those with the 'User Type' equal to "Member". However, there is still a lot of noise, and I would like to add an additional criterion to filter out everything that ends with "@gmail.com".
Could someone please help me modify this formula to include this additional filter?
 
Thank you in advance for your help!
Categories:
I have the same question (0)
  • Suggested answer
    jpespena Profile Picture
    335 on at
    Hi,
     
    You can add the additional filters in your Filter function like this:
     
    Filter(Choices([@'Table1'].'SubmitttedUser'),'User Type'="Member", "@gmail.com" in 'Email Field', Status = "Open")
     

    If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard