Forum Discussion

evajessu's avatar
evajessu
Copper Contributor
May 27, 2020

Personalize a survey : How to configurate my flow ?

Hi,    I am actually working on microsoft flow and forms. I am a bit stuck on making the flow. My aim is to send a personalized survey to a list of contact to collect some information. I have read...
  • RobElliott's avatar
    May 29, 2020

    evajessu in some respects you are looking at this the wrong way round: a flow in Power Automate usually takes the response from Forms and then does something with it, like save it to a list in SharePoint. There is no trigger to send a Forms survey. Also, although the email to the contact can be personalised, you can't use a flow to personalise the survey itself. And the email can only contain the link to the survey, you can't embed the survey in the email.

    To get close to what you want to do you would need to do the following.

     

    1) have a list of the email addresses and names in a SharePoint list or Excel spreadsheet. I've used SharePoint:

     

     

    2) Your flow's trigger is "Manually trigger a flow".  The first action is to get the items from your contacts list. Next, add an apply to each control and select value from the dynamic content. Add a compose control and select the column in your SharePoint list that holds the email address, in my example that is the Title column. Next, add the Send an email (V2) action, select the output of the Compose for the To field. In the body of the email you don'[t really want the ugly long url for the form, so click on the </> code view button and then add in the HTML tags as shown in the image below.

     

    The email that each contact will receive will look like this: 

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources