Filtering the list of managers in a department in People Picker

(0) Share

Report

Posted on by PowerUser19

215

Hello there,

Is there a way to filter only the list of Managers of a specific department in People Picker? I have a People picker field which lists all the users of our organisation. I would like this people picker to show only the managers of a specific department when the user search. Any help on this is really appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerUser19 ,

Could you please tell me that how you configure the specific department?

Here is a simple demo for you.

1). Create a dropdown to get all the departments,Dropdown1 Items:

Filter(Distinct(ForAll(Office365Users.SearchUserV2().value,ThisRecord.Department),Value),!IsBlank(Result))

2). Get all users in a certain department, Dropdown2 Items:

Filter(Office365Users.SearchUserV2().value,Department=Dropdown1.Selected.Result)

3). Get manager of the specific department,TextInput1 Default:

Office365Users.ManagerV2(Dropdown2.Selected.Id).displayName

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

Thanks so much for your response. I would like to get the list of managers of a specific department (which is constant). So I will need to bring the name of the department somewhere in the filter to list the managers of that constant department. The name of the department is not selected from any other field.

I stored the name of the department in a label and tried using that in the 3rd option you provided
Office365Users.ManagerV2(Label38.Text).displayName
It gives me "Expected Table Value" error. Not sure what I am missing here. Attaching the image for your reference.

List of managers who are in "Department X"

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PowerUser19,

Just remove the parameter displayName as below:

Office365Users.ManagerV2(Label38.Text)

Then select the displayName from the field:

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,
Please excuse my ignorance here. I do not see "value" option in my people picker field. I see only "fields" option. I couldn't select "Display Name" in there.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerUser19,

Was this reply helpful? Yes No
PowerUser19 215 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

Thank you. Sorry again. I get the below error
{"sessionId":"701a1c6d-87e7-4bb2-a490-29f3ba2df444","blobUri":"https://docserverpwaprodeau.blob.core.windows.net/c8c589c3-89f8-4478-a6ba-7f3f5b361f81-1/copyResult/copyResult?sv=2017-04-17&sr=b&sig=D7lsSHYK7%2BwsRacnJ62%2FhHwqTdQX7OEJYWpWA5xYo8k%3D&spr=https&se=2022-09-26T23%3A09%3A19Z&sp=r"}

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerUser19，

This is an issue related to your API request, just try to remove the connector and re-connect.

Could you please try to troubleshoot it by yourself if there is an issue unrelated to the one you mentioned?

If the Combo Box is not necessary, I would suggest you use a Dropdown instead, which I have provided the complete solution in my first reply.

Was this reply helpful? Yes No