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 / Email Filtering Data C...
Power Apps
Suggested Answer

Email Filtering Data Card Value

(1) ShareShare
ReportReport
Posted on by 36

This is my scenario:

In my IT request application, there are two approvers: one is the Head of Department (DataCardValue9), and the second is the Admin Department (DataCardValue10).

I need to display only 7 users (O365 Email) in the Head of Department (DataCardValue9) and 2 users (O365 Email) in the Admin Department (DataCardValue10).

But in now it showing all the emails in the domain, therefor anyone can help me fix this, please?

 
Categories:
I have the same question (0)
  • Suggested answer
    jpespena Profile Picture
    335 on at
    Hi,
     
    Are the emails definite? If yes you can use this code to filter:
    Filter(Choices(['DataSource'.'Head of Department'),Email in ("email1@outlook.com, email2@outlook.com...., email7@outlook.com"))
    Change the emails in "" to the specific email you want to use as filter.
     
    Do the same for the Admin Department field.
     

    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!

  • WarrenBelz Profile Picture
    154,494 Most Valuable Professional on at
    Firstly, what is the Items of the two combo boxes and do the targeted users have specific values in their JobTitle and Department in Entra ?
  • WW-25090315-0 Profile Picture
    36 on at
     
    Thank you for your reply; it works, but there's a small issue. I added a few email addresses, but some email IDs appear in the dropdown while others do not. Could you please help me fix this?
     

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 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard