In my example I've started off with a "When a new response is submitted" trigger which should come as no surprise as that's the only trigger. I've then gone straight into the Get Response Details action and selected my Form from the drop down. I then need to provide it with the Response ID which is buried down in the body of the response.
You have two options as to how to get the Response ID, you can use the dynamic text which, because of the object which is returned from the trigger, will put an Apply to Each loop in your Flow. It will only return a single item each time, and you can include your Send Email action within the loop.
If you want something a little bit tidier, you can use an expression to extract the Response ID from the body so that you don't have the loop. This is what I have done in my example below. The expression I have used looks like this:
Hi @cassiedouglas I'm glad that worked for you.
Yes, absolutely. There is an control called "Condition" which allows you to validate a criteria to produce True/False (yes/no) and then you can perform two branches of logic.
E.g. If Rating is equal to 5: email The Boss, otherwise delete the response
Alternatively if you wanted to have multiple legs, then you can use the Switch control which allows you to define multiple courses of action from a single comparison.
Rating = 1: Send email saying you're fired
Rating = 2: Send email saying you need to try harder
Rating = 3: Send email saying you're doing well etc
Thank you so much @MattWeston365 ! I think I only have two more questions. One is there a way to make the responses into a pdf to add as an attachment to the email?
And Lastly- I would like it to be a flow of response happens on one form and it goes to a specific person depending on an answer- I got that far thanks to your help! Now I want them to fill out another form that will start another chain. I get how to set that up but is there a way to let me know if they do not fill out the form? Or to send them reminder emails to fill the form out?
Your help has been awesome and I appreciate it!
Hi @cassiedouglas I'm glad that you're getting there with your solutions, what you're doing sounds quite cool.
I think you'd need to use the populate word document template action, and then convert it to a PDF. I've not tried this personally (yet, but it's on my list), but you can find more info here:
For #2 I would consider having a SharePoint list created so that I can track when someone was sent a Form to complete, and when it was completed. You can set up another Flow using the Recurrence trigger to check on a routine basis to see if the completion date has been populated. If not, send them an email to remind them.
I hope that helps, and I'd be interested to see how you get on with the Word Online actions. I might actually try them myself during my lunch on Monday, so if I get there first, I'll let you know 🙂
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!