Forum Discussion
Power Automate a flow based on Forms submittal
Jleebiker you can use a flow in Power Automate to get each response as it comes in and then do various things with it like add the answers to a list in SharePoint and/or send an email. What you can't do is to run a flow against responses that have already come in as there is no way for Power Automate to get at those responses.
So your flow needs to be set up in advance. Your trigger will be the only Forms trigger available which is "When a new response is submitted". Your first action will be to "Get response details" and for the Response ID field you select from the dynamic content box "List of response notifications Response Id" which is the only thing you can select. After that you can add other actions and in the image I am getting the user details because the form was internal and we can then personalise the email that goes back to them.
Come back with any other questions about build your flow from a Forms response.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
RobElliott is it possible to summarise responses to a form on a daily basis and send one email instead of one email per response?
Rahim_UoB yes but you would need to save each response into a SharePoint list, you can't do it just from the spreadsheet behind the form. Then your flow would get the items from the list with a filter query set to just bring back responses since the previous day. Instead of the normal apply to each you would need a Select action to get the responses, then a create html table action to build the table then a compose action with the CSS styles for the table. Finally you'd add a send email action and put into it the outputs of the previous compose action. We do this daily where a list of desk bookings goes to the relevant building receptionists. The original booking is made via a Power App instead of a Forms form but the follow-on actions are the same.
Rob
Los Gallardos
Microsoft Power Automate Community Super User