SOLVED

How to create a form can select different departments and the managers belong to these department?

Copper Contributor

I have 3 lists, the first one is a staff list store the staff names, the second is department list, I use lookup type column saving managers, from staff list, each department may have multiple managers.


Now, I have the third list, when I add new item, I want to create a form can select different departments and can select managers belong to these departments. What should I do?

1 Reply
best response confirmed by Bowen670 (Copper Contributor)
Solution

@Bowen670 you need customise the form using PowerApps to create that type of lookup. In PowerApps you can add all three lists and then setup filtered galleries to show the managers for the selected department etc

 

1 best response

Accepted Solutions
best response confirmed by Bowen670 (Copper Contributor)
Solution

@Bowen670 you need customise the form using PowerApps to create that type of lookup. In PowerApps you can add all three lists and then setup filtered galleries to show the managers for the selected department etc

 

View solution in original post