Forum Discussion

pickledash's avatar
pickledash
Copper Contributor
Dec 10, 2020

Using dynamic content as email to send email from Form response

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

 

 

  •  

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


     

    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:

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

     

    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

     

     

  • RobElliott's avatar
    RobElliott
    Silver Contributor

     

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


     

    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:

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

     

    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

     

     

    • pickledash's avatar
      pickledash
      Copper Contributor

      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

       

       

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        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

    • NebulaRoss's avatar
      NebulaRoss
      Copper Contributor
      RobElliott
      Thanks for the help with the flow.

      Would you know how to attach a specific sharepoint file to an email notification based on the form response? For example, In my form I have a question with 2 options, Level 1 and Level 2. I need to send a specifc PDF to the responders email depending on if they picked Level 1 or Level 2.
      Any help will be greatly appreciated.
      • RobElliott's avatar
        RobElliott
        Silver Contributor

        NebulaRoss use a switch action and in the "On" field select the question where the level is chosen. Then in each "case" add the actions to send the appropriate PDF.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources