I have a Microsoft Form that first asks a Manager to choose their Department from a dropdown. This menu consists of 17 different Departments. From there, I would like the form to filter the list of 200 employees down to just the employees in that Department. Rather than using Branching, which would be cumbersome to keep updated as employees join or leave departments (or the company), I'm wondering if there is a way to do this using some sort of lookup function using Power Automate and/or Lists.
