Power Platform Community Forum Thread Details

I'm sorry if this has been answered before., I'm brand new to power automate. I have built a flow that sends an email when a form is completed. Now what I'd like is to direct that email to different email addresses based on an answer in the form.

example: sales team in town "A" completes the form for a new order. I want direct it to the fulfilment team for town "A" the issue is I have many teams & many towns but only want to manage one form & flow.

Categories:

Building flows

Hi @GS-27011833-0

To me this would make it simple.

1. Create a List in SharePoint (or Excel, but please use SharePoint).

2. Put in mapping columns TownValue and EmailValue

3. When your flow runs you will use the sharepoint GetItems action, with a filter of TownValue = 'AnswerFromForm'

This will return you 1 row, just one and will get you the Email Address to send too

4. Because you are new, I will make it easier than I would normally

After the GetItems and making sure your filter is correct. I made up Names for columns, you call them whatever you want in SharePoint, but just make sure your OData filter is ColumnName (please do NOT use spaces in your names) = 'FormAnswer' <= and yes surround the DYnamic property of the form answer in single quotes

Now add an Apply to Each

The input will be the value/body Dynamic Property of your GetItems, which normally returns back many things (or it can) but in your case, it will only return 1

Inside the Apply to each add a Send Email V2 to send the email. I am assuming you are using Outlook and Office, if not then change to Gmail or whatever.

In your Email Address field put in

item()?['EmailValue']

item() represents the current iteration of your Apply to each. Since you will only loop one time we are good

the rest of the expression will return the email address you put into the EmailValue column (that I made up in my example) and then you will send the email to them.

So you can have 1000 Towns and Email Addresses mapped together. you can even make the EmailValue multiple people

michaelATtest.com;youATtest.com etc just seprate them by a ; for Office/Outlook

And done :-)

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey