I have 2 Sharepoint Lists:
1. Primary list that is connected to a Power App where users go in and submit forms
2. Secondary list with Email addresses (text), Managerial level of individual and the Facility they belong to
I'm creating a Flow to check the Sharepoint list every morning to see if the Form(s) submitted are at the stage where their approval is needed. Who is emailed depends on the Facility chosen when the user submitted the form.
I know I could basically initialize a variable for each Facility and each Managerial position (i.e. Facility1 - Mgr1, Facility1 - SrMgr1, Facility2 - Mgr1, etc) and then create individual flows for each manager however due to the limitations on how many Conditions you can have (I think 9?) it would end up requiring a ton of Flows just to manage the reminder emails.
Is there a better / more efficient way to achieve this where I could look at the Facility of the form and somehow use that to pull the email from the mgr list?
(I wanted to use a separate list to manage the users so the department could handle changing of the managers when staffing changes instead of needing to change the flows themselves)
I'm still fairly new to the more advanced programming aspects of Flow and I'm kind of stuck on the best method to achieve this.
