SOLVED

Using dynamic content as email to send email from Form response

%3CLINGO-SUB%20id%3D%22lingo-sub-1975113%22%20slang%3D%22en-US%22%3EUsing%20dynamic%20content%20as%20email%20to%20send%20email%20from%20Form%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1975113%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20searched%20through%20the%20forum%20to%20see%20if%20this%20has%20been%20answered%20but%20can't%20seem%20to%20see%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20set%20up%20a%20Flow%20that%20allows%20me%20to%20Send%20an%20email%20to%20the%20email%20addresses%20I%20chose%20within%20the%20form.%20I%20am%20selecting%20dynamic%20content%20for%20one%20person%20to%20be%20sent%20and%20also%20two%20people%20to%20be%20CC'd%20in%20and%20their%20email%20address%20is%20typed%20as%20a%20response%20to%20each%20question%20on%20the%20form.%20Is%20this%20possible%3F%20I've%20tried%20but%20no%20email%20is%20getting%20sent%20on%20the%20test%20runs%20I%20am%20conducting.%20I've%20tried%20using%20an%20If%20function%20at%20first%20but%20realised%20it%20won't%20work%20as%20there%20are%20too%20many%20variables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1975113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1975315%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20dynamic%20content%20as%20email%20to%20send%20email%20from%20Form%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1975315%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F897156%22%20target%3D%22_blank%22%3E%40pickledash%3C%2FA%3E%26nbsp%3Byes%20this%20is%20very%20straightforward%20and%20a%20simple%20example%20is%20shown%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-Form.png%22%20style%3D%22width%3A%20947px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239506i39D8301248CAD456%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%220-Form.png%22%20alt%3D%220-Form.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239503iB73E9C1F90EEE280%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20a%20shared%20mailbox%20as%20in%20my%20company%20we%20always%20use%20those%20instead%20of%20automated%20emails%20coming%20from%20an%20individual's%20email%2C%20but%20you%20could%20just%20as%20easily%20use%20the%20Send%20an%20email%20(v2)%20action.%20Make%20sure%20between%20the%202%20cc%20addressees%20that%20you%20add%20a%20semi-colon%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Flow.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239505iB280A54D833EA928%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-Flow.png%22%20alt%3D%222-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BAnd%20this%20is%20the%20result%20of%20the%20form%20in%20one%20of%20the%20cc%20addresses.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-Emailcc.png%22%20style%3D%22width%3A%20586px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239504iD8372F056EC45DE8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223-Emailcc.png%22%20alt%3D%223-Emailcc.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20you%20are%20doing%20anything%20different%20to%20this%20post%20a%20screenshot%20and%20we%20can%20have%20a%20look.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1975981%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20dynamic%20content%20as%20email%20to%20send%20email%20from%20Form%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1975981%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Rob%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20the%20reply%2C%20I%20have%20managed%20to%20get%20it%20working!%20I'm%20sure%20what%20I%20have%20done%20different%20apart%20from%20the%20semi%20colon%20but%20it%20appears%20to%20have%20got%20it%20going.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20one%20thing%20that%20is%20not%20working...I've%20tried%20to%20set%20it%20up%20so%20that%20the%20email%20comes%20from%20the%20person%20who%20has%20filled%20out%20the%20response.%20So%20I've%20put%20'Responders'%20email'%20in%20the%20'From%20(Send%20as)%20box%20but%20it%20doesn't%20work%20and%20only%20works%20when%20I%20fill%20in%20the%20response.%20I%20think%20the%20plan%20is%20to%20have%20it%20come%20from%20a%20shared%20group%20inbox%20in%20the%20future%20but%20for%20now%20I've%20thought%20of%20this%20as%20a%20workaround.%20Can%20this%20be%20done%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1976034%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20dynamic%20content%20as%20email%20to%20send%20email%20from%20Form%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F897156%22%20target%3D%22_blank%22%3E%40pickledash%3C%2FA%3E%26nbsp%3Bno%20you%20can't%20do%20that%2C%20the%20send%20an%20email%20will%20always%20come%20from%20you%20if%20you%20use%20the%20Send%20an%20email%20(v2)%20action.%20If%20you%20use%20the%20Send%20as%20field%20in%20the%20action%20the%20person%20who%20has%20submitted%20the%20form%20needs%20permissions%20to%20send%20from%20your%20email.%20That's%20one%20of%20the%20reasons%20we%20always%20use%20a%20shared%20mailbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1976069%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20dynamic%20content%20as%20email%20to%20send%20email%20from%20Form%20response%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3Bahh%20ok%20I%20see.%20So%20a%20work%20around%20for%20now%20could%20be%20that%20I%26nbsp%3B%20grant%20everyone%20who%20will%20be%20filling%20out%20the%20form%20access%20to%20my%20outlook%20account%20and%20I%20will%20give%20them%20permission%20to%20send%20emails%20on%20my%20behalf%3F%20But%20then%20when%20the%20form%20is%20then%20emailed%20to%20whoever%20the%20email%20will%20come%20from%20the%20respondents%20email%20address%3F%20Sorry%20If%20I%20have%20misunderstood%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All

 

I've searched through the forum to see if this has been answered but can't seem to see it.

 

I'm trying to set up a Flow that allows me to Send an email to the email addresses I chose within the form. I am selecting dynamic content for one person to be sent and also two people to be CC'd in and their email address is typed as a response to each question on the form. Is this possible? I've tried but no email is getting sent on the test runs I am conducting. I've tried using an If function at first but realised it won't work as there are too many variables.

 

Thanks in advance

 

Regards

 

 

8 Replies
best response confirmed by pickledash (Occasional Contributor)
Solution

 

 @pickledash yes this is very straightforward and a simple example is shown below:

0-Form.png
1-Flow.png

 

I've used a shared mailbox as in my company we always use those instead of automated emails coming from an individual's email, but you could just as easily use the Send an email (v2) action. Make sure between the 2 cc addressees that you add a semi-colon:

2-Flow.png

 And this is the result of the form in one of the cc addresses.

3-Emailcc.png

 

So if you are doing anything different to this, post a screenshot and we can have a look.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

 

Hi Rob

 

Many thanks for the reply, I have managed to get it working! I'm sure what I have done different apart from the semi colon but it appears to have got it going.

 

There is one thing that is not working...I've tried to set it up so that the email comes from the person who has filled out the response. So I've put 'Responders' email' in the 'From (Send as) box but it doesn't work and only works when I fill in the response. I think the plan is to have it come from a shared group inbox in the future but for now I've thought of this as a workaround. Can this be done?

 

Regards

 

 

@pickledash no you can't do that, the send an email will always come from you if you use the Send an email (v2) action. If you use the Send as field in the action the person who has submitted the form needs permissions to send from your email. That's one of the reasons we always use a shared mailbox.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott ahh ok I see. So a work around for now could be that I  grant everyone who will be filling out the form access to my outlook account and I will give them permission to send emails on my behalf? But then when the form is then emailed to whoever the email will come from the respondents email address? Sorry If I have misunderstood

 

 

@pickledash that workaround is a really bad idea and certainly at my company (65,000 staff) is not allowed without a very good reason. You are much better creating & using a shared mailbox.


Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Hi Rob, if I have access to a group inbox. Do you know how I would get the email that sends out the information from the Mircosoft Form to send from that group inbox instead of my own personal work email?

 

Regards

 

 

@pickledash you need to use the Send an email from a shared mailbox (v2) action in Power Automate. In the image below the email is sent from the reippsupport shared mailbox:

sharedMailbox.png