Filter search records by department?

(0) Share

Report

Posted on by ritzadog

Hi,

We have 2 Departments in AAD. (Staff/Students). What´s wrong with my filter/search ? Can´t get this working.

If(!IsBlank(Trim(TextSearchBox.Text));Office365Users.SearchUser(
{
searchTerm: Trim(TextSearchBox.Text);
Filter(Office365Users.SearchUser({searchTerm:""}),Department = "Staff");
top: 15
}
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ritzadog , try:

Filter(Office365Users.SearchUser({searchTerm:Trim(TextSearchBox.Text),top:15}),Department="Staff")

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Ngo-Cong-Tuyen 91 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, @ritzadog
You can change to this:
Filter( If( !IsBlank(Trim(TextSearchBox1.Text)), Office365Users.SearchUser( { searchTerm: Trim(TextSearchBox1.Text), top: 15 } ) ),Department= "Staff")

Was this reply helpful? Yes No
ritzadog 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Ngo-Cong-Tuyen - This worked fine and solved my problem!

Was this reply helpful? Yes No