Email Filtering Data Card Value

(1) Share

Report

Posted on by WW-25090315-0

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

jpespena 335 on at

Like (1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
WW-25090315-0 36 on at

Like (0)

Report
Copy link

Link copied!

Hi jpespena

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?

Was this reply helpful? Yes No