Answered

Email Filtering Data Card Value

(0) Share

Report

Posted on by WW-25090315-0

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).

I have used this code to filter emails.

Filter(Choices(['CHEC IT Facility Request'.'Head of Department'),Email in ("email1@outlook.com, email2@outlook.com...., email7@outlook.com"))

But in this code, some emails do not appear in the list, and searching does not work. please help me to fix this

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 35,805 Super User 2025 Season 2 on at

Like (1)

Report
Email Filtering Data Card Value

Hi WW-25090315-0

I suspect the cause of this is because you've use round brackets rather than square brackets to provide the list of email addresses. Does this make a difference?

Filter( Choices(['CHEC IT Facility Request'].'Head of Department'), Email in ["email1@outlook.com", "email2@outlook.com", ..., "email7@outlook.com"] )

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

Like (0)

Report

Email Filtering Data Card Value

Fixed with below code
Items =

Filter(
Office365Users.SearchUser({searchTerm: DataCardValue9.SearchText, top: 999}),
Find("Display Name", DisplayName) > 0 || Find("Display Name", DisplayName) > 0 || Find("Display Name", DisplayName) > 0
)

Update =

{
Claims: "i:0#.f|membership|" & Lower(DataCardValue9.Selected.Mail),
DisplayName: DataCardValue9.Selected.DisplayName,
Email: DataCardValue9.Selected.Mail,
Department: "",
JobTitle: "",
Picture: ""
}

Was this reply helpful? Yes No