Mar 18 2020 07:40 PM
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?
Mar 19 2020 12:40 AM
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
Mar 19 2020 12:40 AM
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