Good afternoon,
I'm encountering a mental block that I believe should be simple. I need to create a basic database (perhaps an Excel table?) that lists managers and their locations, as defined in the "Department" attribute. Essentially, when running a flow, I need to match the department of the manager in the database with the user running the flow. Based on that match, I may need to automatically fill in the manager's email for an Outlook action to send an email. Most of these managers are not direct reports, so the "Manager" attribute won't work for this purpose.
Thank you for your help.
