Unanswered

Employee Directory : Search by Name or Department

(0) Share

Report

Posted on by bgreen1

Created a company directory. I want a user to be able to search employees by name or department.

In this formula, I want the user to be able to search for the employee by first name or department by entering the information in a single text box. However the formula doesn't work

If( !IsBlank(Trim(TextSearchBox1.Text)), FirstN( Filter( Office365Users.SearchUser({ searchTerm: TextSearchBox1.Text, top: 999 }), Or( !IsBlank(Department), First(Lower(Split(DisplayName, " "))) = Lower(Trim(TextSearchBox1.Text)) ) ), 15 ) )

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bgreen1

Please try :

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

Best Regards,

Levi

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bgreen1

Your formula looks correct.

Best Regards,

Levi

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

think this is the issue. might you know how to get more the 999 users ?

https://powerusers.microsoft.com/t5/Building-Power-Apps/GET-ALL-USER-FORM-OFFICE-365/m-p/1582423

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

do you know how to include more than 999 in the search?

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

If(
!IsBlank(Trim(TextSearchBox1.Text)),
FirstN(
AddColumns(
Office365Users.SearchUser(
{
searchterm: "",
top: 500
}
),
"PageIndex", 1
),
999
),
Filter(
AddColumns(
Office365Users.SearchUsersNextPage(
First(Filter(Office365Users.SearchUser({searchTerm:"",top:1}), true)).Id,
FirstN(
Filter(
AddColumns(
Office365Users.SearchUser(
{
searchterm: "",
top: 500
}
),
"PageIndex", 1
),
!IsBlank(Department),
(TextSearchBox1.Text in DisplayName || TextSearchBox1.Text in Department)
),
499
),
First(Filter(Office365Users.SearchUser({searchTerm:"",top:1}), true)).Value
),
"PageIndex", 2
),
!IsBlank(Department),
(TextSearchBox1.Text in DisplayName || TextSearchBox1.Text in Department)
)
)

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bgreen1

This link points to how to search beyond the 999 limit:

Solved: Re: GET ALL USER FORM OFFICE 365 - Power Platform Community (microsoft.com)

Best Regards,

Levi

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!
Yes with formula below can I search beyond 999 limit ?
If( !IsBlank(Trim(TextSearchBox1.Text)), Filter( Office365Users.SearchUser( { searchterm: "", top: 999 } ), !IsBlank(Department)&& (TextSearchBox1.Text in DisplayName || TextSearchBox1.Text in Department) )

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @bgreen1

This formula cannot exceed the limit of 999.

Best Regards,

Levi

Was this reply helpful? Yes No
bgreen1 54 on at

Like (0)

Report
Copy link

Link copied!

Is it possible to create a formula to exceed the 999 limit ?

Was this reply helpful? Yes No