SOLVED

MS Forms response in E-mail

%3CLINGO-SUB%20id%3D%22lingo-sub-1480244%22%20slang%3D%22en-US%22%3EMS%20Forms%20response%20in%20E-mail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20fairly%20basic%20Form%20which%20I%20would%20like%20to%20be%20completed%20for%20New%20Starter%20Requests.%3C%2FP%3E%3CP%3EThe%20goal%20is%20to%20have%20the%20form%20completed%20and%20then%20using%20a%20Flow%20send%20the%20details%20to%20our%20ticketing%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%2C%20I%20would%20like%20to%20have%20the%20Subject%20set%20as%20'New%20Starter%20-%26nbsp%3B%3CEM%3Estarter%20name%3C%2FEM%3E'%20by%20pulling%20data%20out%20of%20the%20form.%3CBR%20%2F%3EThe%20body%20would%20then%20be%20the%20remaining%20questions%20from%20the%20form.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20able%20to%20have%20a%20mail%20sent%20out%2C%20but%20the%20only%20availaible%20expression%20I%20can%20see%20is%20the%20response%20id%20-%20which%20is%20useless%20to%20me%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20I%20pass%20the%20details%20of%20the%20form%20response%20into%20an%20E-mail%20via%20a%20Flow%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thank%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480244%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1480309%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Forms%20response%20in%20E-mail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480309%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706410%22%20target%3D%22_blank%22%3E%40PieOPah_UK%3C%2FA%3E%26nbsp%3Byes%20you%20can%20send%20the%20contents%20of%20the%20form%20via%20email%20but%20you%20can't%20have%20it%20sent%20from%20the%20person%20completing%20the%20form.%20The%20email%20will%20always%20be%20sent%20by%20you%20if%20you%20use%20the%20%3CEM%3ESend%20an%20email%20(v2)%3C%2FEM%3E%20action%20in%20your%20flow%2C%20or%20by%20Microsoft%20PowerApps%20and%20Flow%20if%20you%20use%20the%20%3CEM%3ESend%20an%20email%20notification%20(v3)%3C%2FEM%3E%20action.%20What%20we%20do%20our%20business%20is%20to%20send%20flows%20from%20a%20shared%20mailbox%2C%20so%20emails%20will%20come%20from%20the%20name%20of%20that%20shared%20mailbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20its%20simplest%20the%20forms-to-email%20flow%20just%20needs%20the%20%3CEM%3EWhen%20a%20new%20response%20is%20submitted%3C%2FEM%3E%20trigger%20followed%20by%26nbsp%3Bthe%20%3CEM%3EGet%20response%20details%3C%2FEM%3E%20action.%20Then%20you%20can%20have%20any%20actions%20after%20that.%20I%20always%20save%20form%20responses%20into%20SharePoint%20as%20one%20of%20the%20actions%20but%20if%20you%20just%20want%20to%20send%20an%20email%20then%20the%20flow%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22simpleFormEmail.png%22%20style%3D%22width%3A%20902px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199998i929E79DE345DE2B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22simpleFormEmail.png%22%20alt%3D%22simpleFormEmail.png%22%20%2F%3E%3C%2FSPAN%3E%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%23333399%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491467%22%20slang%3D%22en-US%22%3ERe%3A%20MS%20Forms%20response%20in%20E-mail%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491467%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20for%20such%20a%20late%20response%20-%20been%20a%20busy%20week%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20works%20perfectly.%3C%2FP%3E%3CP%3EIn%20my%20test%20run%20it%20gives%20the%20exact%20information%20that%20I%20require.%3CBR%20%2F%3ENext%20stage%20is%20to%20set%20the%20flow%20to%20run%20as%20a%20system%20account%20which%20will%20be%20allowed%20'Send%20As'%20permission%20on%20everyone's%20mailbox.%20This%20SHOULD%20fix%20the%20issue%20of%20being%20able%20to%20send%20as%20the%20person%20submitting%20the%20form%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%20for%20your%20help%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have created a fairly basic Form which I would like to be completed for New Starter Requests.

The goal is to have the form completed and then using a Flow send the details to our ticketing system.

 

Ideally, I would like to have the Subject set as 'New Starter - starter name' by pulling data out of the form.
The body would then be the remaining questions from the form.

I am able to have a mail sent out, but the only available expression I can see is the response id - which is useless to me :)

If possible I would also like the E-mail to be sent from the person completing it.


Can I pass the details of the form response into an E-mail via a Flow?

Many thank,

2 Replies
best response confirmed by PieOPah_UK (New Contributor)
Solution

@PieOPah_UK yes you can send the contents of the form via email but you can't have it sent from the person completing the form. The email will always be sent by you if you use the Send an email (v2) action in your flow, or by Microsoft PowerApps and Flow if you use the Send an email notification (v3) action. What we do our business is to send flows from a shared mailbox, so emails will come from the name of that shared mailbox.

 

At its simplest the forms-to-email flow just needs the When a new response is submitted trigger followed by the Get response details action. Then you can have any actions after that. I always save form responses into SharePoint as one of the actions but if you just want to send an email then the flow looks like this:

 

simpleFormEmail.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

 

 

Sorry for such a late response - been a busy week :)

This works perfectly.

In my test run it gives the exact information that I require.
Next stage is to set the flow to run as a system account which will be allowed 'Send As' permission on everyone's mailbox. This SHOULD fix the issue of being able to send as the person submitting the form :)

Many thanks for your help with this.