web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Manager should be filt...

Power Apps

Answered

Manager should be filter as per user login

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everyone,

I am developing app where manager will get filter as per user login so I have develop database as person type and in PowerApps I am using dropdown where name of managers will get filter as per user login and also I have created employee column in database where particular manager is allotted to employees.
Eg : A employee is allotted x manager B employee is allotted y manager so whenever A employee login x manager should be automatically filter in dropdown using filter function.

Regards,

Sagar Shah

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous
Suppose you have a table called 'Employees List' with 2 columns of 'Person Type'.

Employee Manager

Employee A Manager A

Employee B Manager A

Employee C Manager A

Employee D Manager B

Employee E Manager B

Put this code in the Onstart property of the App to get the Manager's email

Set(varUser, User().Email)

Then use this code in the Items property of the Combobox used to select an employee

Choices('Employees List'.Manager)

Put this code in both the DisplayFields and SearchFields property of the ComboBox.

["Display Name"]

Finally, use this code in the DefaultSelectedItems property of the ComboBox

LookUp('Employees List', Employee.Mail = varUser, Manager)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to filter manager based on employee ?

Could you tell me
1)is your data source sharepoint list?

2)are manager and employee field both user type?

3)whether these two fields allow multiple value?

I assume that you use sharepoint list ,manager and employee field both are user type, not allow multiple value.

Then you should set like this:

the drop down's Items:

Distinct(Filter('Employees List', Employee.Email=User().Email), Manager.Email)

Then the drop down will only list the related manager's email.

Best regards,

Join the conversation