Share
Report
7Hi
I have built a Flow from emails I receive the emails are from a site that send me data in specific format one of the points of data is a region which is a drop down option in my form so it has set values. I am able to parse the information from the email no issue but I need to send an email from power automate to the manager of that region.
Since I currently have 7 different flows that are automated that send information to managers if one or more of them change over time it means that I will need to change the information in each of those flows. My solution is that I have built a single SharePoint list with the regions, first and last name and the managers email address so that I can just update that list once and all the flows should in theory update the outputs when sending out the email.
Sample Table
| First Name | Last Name | Region | |
| Mandy | Soap | soap@myemails.com | Eastern Region |
| Greg | Pizza | pizza@myemails.com | Mid-West Region |
The region spelling and case will always match the regions in the table but I am wondering if I can find the region row and extract the email, first and last name.
I am just at a loss on how to do it in Power Automate and will be extremely grateful for any help.
Kind regards
Matt
All responses (
Answers (
