
Hi,
I have a Microsoft Form used to capture information from cold calls/inquiries. One of the questions asks to which of our offices should the information be directed for follow-up and lists as the options the geographic locations of our offices (e.g. "Georgia (Atlanta)", "North Carolina (Chapel Hill)", etc.) with the ability to select multiple if the inquiry concerns multiple states.
Using Power Automate, for each submission of the Form, I would like for an email to be automatically sent to the designated representative for each office selected.
I currently have a Select data operator to map the multiple-choice responses. But I'm not sure where to take the output from there to link each office selected with an email address for the representative from each office and, from there, input those emails into the "Get User Profile" and "Send an Email" functions.
Is what I'm trying to do possible? If so, what would be the easiest way to accomplish this? Let me know if I can clarify anything.
Many thanks,
Liam