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 So I'm doing some conditional branching. What is the best practice for having branches for 14 conditions? Where, how is best to put the conditions in?
- RobElliottAug 14, 2020Silver Contributor
Jleebiker you don't want to use a condition in that case if you are just looking at the answer to the "Please select....." question. Instead you should use a type of condition called a Switch. That will add "Cases" to your flow: in case the answer is Adobe then do x, y and z; in case the answer is Microsoft then do x, y and z etc. You can up to 27 of these cases in each Switch. In the example below the email goes to a different person depending on the department selected.
As you will have to have the actions in each case channel don'#t forget you can copy actions to your clipboard from the 3 dots at the top right of each action and then in other channels select the action from the clipboard.
Rob
Los Gallardos
Microsoft Power Automate Community Super User