More efficient way to send emails based on SP List choice field

[Jawsch]

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.

[edgonzales]

@Jawsch 

Hi there.  There are a few ways to approach this, I think...here are a couple:

• Using the same methodology you have now, but use a Switch action rather than nested conditions.  Switches let you set up conditions with non-binary (true/false) responses.
• Create a third table/List (in Excel, SharePoint, CDS, doesn't really matter) that lists the Facility and corresponding eMail address.  Then, once you have the info facility info, you can do a List Items, or Get Records type action, and filter on that facility.  This method would be advantageous if the email addresses changed and/or you would use the same kind of list in other automations.  

Either way, keep us posted.  Good luck!

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[Jawsch]

@edgonzales 

Ahh! I don't even know why Switch didn't come to mind, I've used them often in Power BI. Never even realized there was a control for that. I think that would likely be the best option and I'll give it a go.

Thank you!