Answered

Office365Users.SearchUserV2 - Search by DisplayName or Department

(0) Share

Report

Posted on by EAscencio

Hello,

I am currently developing a Phone Directory PowerApp in which I can search for a user by DisplayName (First name or last name) and Department.

I currently have the Items property of the gallery set to:

If(
 !IsBlank(Trim(SearchBox.Text)),
 Filter(
 Office365Users.SearchUserV2(
 {
 isSearchTermRequired: false,
 top: 2000
 }
 ).value,
 AccountEnabled = true,
 !IsBlank(JobTitle) && !IsBlank(Surname) && (SearchBox.Text in DisplayName || SearchBox.Text in Department)
 )
)

I have several filters to not display users without a job title or a surname as this will allow me to search by DisplayName and Department however it is not returning any users past the letter "S".

If I change "isSearchTermRequired: false" to "searchTerm: SearchBox.Text" i am able to pull the entire list of users but not able to search by Department.

Any help is appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @EAscencio

You can write a similar expression:

If(
!IsBlank(Trim(SearchBox.Text)),
Filter(
Office365Users.SearchUserV2(
{
isSearchTermRequired: true,
searchTerm: SearchBox.Text, // Use the search term
top: 2000
}
).value,
AccountEnabled = true,
!IsBlank(JobTitle) && !IsBlank(Surname) &&
(SearchBox.Text in DisplayName || SearchBox.Text in Department)
)
)

I hope this helps 🙂

Was this reply helpful? Yes No
EAscencio 11 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much, this worked like a charm!

Was this reply helpful? Yes No
EAscencio 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm sorry, I may have spoken too soon out of excitement. However I am still not able to search for users with the same Department.

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@EAscencio

Try this :

If(
!IsBlank(Trim(SearchBox.Text)),
Filter(
Office365Users.SearchUserV2(
{
searchTerm: SearchBox.Text, // Use searchTerm instead of isSearchTermRequired
top: 2000
}
).value,
AccountEnabled = true,
!IsBlank(JobTitle) && !IsBlank(Surname) && (SearchBox.Text in DisplayName || SearchBox.Text in Department)
)
)

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @EAscencio

I used this and it worked try this:

Filter(
Office365Users.SearchUser(
{searchTerm: TextInput7.Text, top: 500}),
StartsWith(Department, DropdownDepartment.Selected.Value)
)

I made a dropdown and in it I kept some departments. You can keep more:

[
"Human Resources",
"Information Technology (IT)",
"Finance",
"Sales",
"Marketing",
"Customer Support",
"Research and Development (R&D)",
"Operations",
"Production",
"Quality Assurance",
"Legal",
"Administration",
"Engineering",
"Logistics",
"Management"
]

Was this reply helpful? Yes No
EAscencio 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm i think this solution would require me to manually manage the department names. Is it not possible to search for users based on Username or Department in the SearchBox?

Was this reply helpful? Yes No