Forum Discussion
Microsoft forms - How can I add multiple recipients to get notifications once a form is completed?
RobElliott Hi! This was very helpful. I followed your steps and was able to get the email sent to the correct inbox. I was wondering if there is also a way to embed the direct link to the form in autogenerated email? Having the responses is good, but being able to click back to the original form in that email would be helpful! Is this possible?
jwhitfie Greg-Growney you just need to select the link icon in the Send email action and add in the url of your form and the text you want to display.
The other method is if you are using the code view in the email body (which we normally do at our company as we add our logo into the emails):
<a href="url to form goes here">Link to form</a><br><hr>
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RTaylor1270 sorry, for some inexplicable reason I've only just seen your question. The dropdown is populated from the forms you create as personal forms. If they are Group forms you will need to select custom value and paste in the form ID.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)RobElliott Do you know where Power Automate pulls the list of forms for in the Form Id drop-down in "When a new response is submitted"? I have created forms but I always have just "No items" and "Enter custom value" in this selectable list when I create a new flow. Thanks
kellynic to do this you should create a group which you can do in Outlook. After a few minutes it will appear in Forms. Go to the All my forms screen and click the 3 dots at the bottom right of the form. Select Move then the group you want to move the form to. Go back to the form and open the spreadsheet. It will sync for a few seconds then you'll see it in the Dpocuments library for the group.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)kellynic - if you combine, Forms with Microsoft List & Power Automate, you can achieve this. I have my form set up that my team submits it, (using power automate) it has automated a process to have the answers to the form populate on Microsoft List AND send emails out to the party that needs the notification.
Thankyou for this thread as a total beginner to Power Automate, this has helped loads! One question, if I want my Form results to also populate automatically into an Excel Spreadsheet do I need a separate flow or can it exist with the one I've already created to email multiple recipients?
SteveCRF A group form doesn't appear in the dropdown; you need to paste in the form ID into both the "when a new response is submitted" trigger and the "get response details" action.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- * My colleague and I have been endeavouring to leverage the useful wisdom added to this thread by RobElliott and others
* We have a MS Form that after the user accepts the form, leads to an new row being appended to an MS Excel spreadsheet stored in SharePoint
* We would like Power Automate to allow the spreadsheet being updated to trigger a notification email to a handful of internal email ids (this seems similar to the line of this thread; I am though humbly open to correction on that)
* The roadbloack my colleague and I have is that the MS Form in question isn't available for selection from the drop down menu when seek to create an automated flow
* The MS Form is stored in the same SharePoint as the excel spreadsheet
Can anyone help please by pointing out our folly?
Any help is much appreciated.
Regards,
Steve Thanks so much!
Stonecor222 yes, you can add a switch action - a type of condition that looks at just 1 thing, for example the Forms question "Which department are you in?". Each switch can have up to 27 "cases". So in case department is equal to Engineering then send the email to people a,b and c. In case department is equal to warehouse then send the email people w, x, y and z. So you need a question which will allow the flow to route each response appropriately. Here's one of ours:
Rob
Los Gallardos
Microsoft Power Automate Community Super UserHi Rob,
Are you able to set up a flow that can send confirmation responses to a larger group of people? For example, I want to have a survey response confirmed by a different person for each respondent.
Thanks!
Bfreire sory, I know nothing about that error message.
Yes, you need to type the questions manually into the email, there is no way round that.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)RobElliott I need that another person in Microsoft gets notification when I receive a response in Forms. I have been trying to do it using power automate flow with the link of the results based on earlier post's instructions. However, I received this error:
Can you please advise? The other option I noticed in the posts requires that I type every single question, and this is very unproductive since I have to do it for different forms and each form has a lot of questions.
