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?
@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