Unanswered

Directory Search by Display Name and Department Name

(0) Share

Report

Posted on by bgreen1

Hi, I created a directory and would like to search by department and display name when searching. In addition, exclude users who don't have a department name. The script below works but doesn't search by the department as well.

 If(!IsBlank(Trim(TextSearchBox1.Text)), FirstN(Filter(Office365Users.SearchUser({searchTerm: Trim(TextSearchBox1.Text), top: 999}),!IsBlank(Department)),15))

So I tried the one below but it has now filtered most of my users but I only want to filter the ones who don't have a department.

 If(!IsBlank(Trim(TextSearchBox1.Text)), FirstN(Filter(Office365Users.SearchUser({top: 999}),!IsBlank(Department)&&(TextSearchBox1.Text in DisplayName || TextSearchBox1.Text in Department)),15))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bgreen1 ,

I'm not quite sure if you want someone who has a department name or someone who doesn't. According to the second formula you provided, you will get all the people who have department names and then search for their department names and DisplayNames.

If you mean to filter by department name if the person has a department name, and filter by DisplayName if there is no department name, then the formula be:

If( !IsBlank(Trim(TextSearchBox1.Text)), FirstN( Filter( Office365Users.SearchUser({top: 999}), (!IsBlank(Department)&&TextSearchBox1.Text in Department)|| (IsBlank(Department) && TextSearchBox1.Text in DisplayName ) ),15) )

Best Regards,
Bof

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

Hi Bof,

Yes I want to be able to search someone who has a department name and displayname. For example if I search Information Technology everyone in information technology names will display. Also, if I search last name green evertyone last name green will show. Also, I want to set a filter if someone doesnt have a department name to exclude them. With the second formula when I search Information technology non of the employees display.

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!
Yes correct,

However, the text below doesnt filter by DisplayName if there is no department name.
If( !IsBlank(Trim(TextSearchBox1.Text)), FirstN( Filter( Office365Users.SearchUser({top: 999}), (!IsBlank(Department)&&TextSearchBox1.Text in Department)|| (IsBlank(Department) && TextSearchBox1.Text in DisplayName ) ),15) )

Was this reply helpful? Yes No