Forum Discussion
Microsoft forms - How can I add multiple recipients to get notifications once a form is completed?
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?
kellynic If I understand your needs right, this already happens within Microsoft forms. Go to the form > responses > view in excel. This is the live spreadsheet that collates all responses.
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.
