Filter Officer365Users by department

(0) Share

Report

Posted on by indhaa

Hi,

I would like to include in the people picker users that match some departments only but I'm unable to do so

I tried to use

Filter(Office365Users.SearchUser({searchTerm:PeoplePicker_3.SearchText}),!IsBlank(JobTitle)&&!IsBlank(Mail)&&!IsBlank(Department)&&
("AB Department" in Department ||
"BC Department" in Department ||

"XY Department" in Department
)
)

But no luck. Any idea what I'm doing wrong. It is working if I only include one department in the filter

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

mahoneypat 1,720 on at

Like (1)

Report
Copy link

Link copied!

Please see if this syntax works.
Filter(Office365Users.SearchUser({searchTerm:PeoplePicker_3.SearchText}),!IsBlank(JobTitle)&&!IsBlank(Mail)&&!IsBlank(Department)&&
Department in ["AB Department", "BC Department", "XY Department"]
)
Pat

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

It shows as invalid syntax

Was this reply helpful? Yes No
mahoneypat 1,720 on at

Like (1)

Report
Copy link

Link copied!

I tried it out successfully on my end. I must have keyed something in wrong. I made a button that created a collection with similar structure below

ClearCollect(colEmployees, Table({Name: "Joe", Title: "Manager", Department: "A"}, {Name: "Mary", Title: "Director", Department: "B"}, {Name: "Tom", Title: "Manager", Department: "C"}, {Name: "Joe", Title: "Manager", Department: "C"}))

And then Filtered it in a gallery.

Filter(colEmployees, !IsBlank(Name) && !IsBlank(Title) && Department in ["A", "B"])

Regards,
Pat

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

My data connection is to Office365Users and filtering the users using that. Not using a gallery
Any idea how to filter within my data source

@RandyHayes

Was this reply helpful? Yes No
Verified answer

indhaa on at

Like (0)

Report
Copy link

Link copied!

I tried with this. It is working now Filter(Office365Users.SearchUser({searchTerm:ComboBox1.SearchText}),"AB" in Department || "CD" in Department || "DE" in Department || "FG" in Department)

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

Seem the issue was there was a spelling mistake when naming the department. That's why it was not working before. Thanks for the help @mahoneypat

Was this reply helpful? Yes No