Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Email Filtering Data Card Value

Posted on 29 Nov 2024 10:27:33 by 22

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:
  • WarrenBelz Profile Picture
    WarrenBelz 143,168 on 29 Nov 2024 at 11:03:49
    Email Filtering Data Card Value
    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 ?
  • Suggested answer
    jpespena Profile Picture
    jpespena 227 on 29 Nov 2024 at 10:59:16
    Email Filtering Data Card Value
    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!

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,168

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,851

Leaderboard