Microsoft Power Automate - How to get Forms responses to Excel and Email - Full Tutorial

This video guide shows how to get responses from Microsoft Forms to Excel with Power Automate. It's also shown how to apply a condition on the Forms data and send an email.

You could also watch:

FOLLOW ME:

0:00 Power Automate Forms to Excel
This use case shows, how to export the data from Forms and import it into Excel and Email. The Excel sheet could either be on OneDrive or SharePoint.

0:48 Excel Data on OneDrive
The mission is to import our Forms data to the Excel sheet in OneDrive.

1:13 Trigger Based Flow in Power Automate
Our trigger will be when a new response is submitted in Forms. Remember to have the 'Split Off' to not have our string stored as an array.

1:56 Apply to Each
We use an Apply to Each to get our list of responses and then get the response details.

2:35 Add a row into a table
Adding the response details to a new row in our Excel Sheet in OneDrive

5:49 Apply a condition to the Forms responses
Applying a condition to our data to find our, when we get a bad review in our survey. This should trigger an email to us.

7:38 Send me an email notification
We send ourselves an email notification, when we get a bad review.

#powerautomate #forms #flow

[andersjensenorg]

Thanks for all your support and nice comments 🙌🔥❤
Kind regards, Anders

[boitumeloatzm]

Hi Anders. Thank you so much, this was clear and to the point - very helpful! Presentation was a little fast at times, but content was spot on. Great stuff.

[shazerator]

This was amazing! One thing to note (maybe is already mentioned in other comments) as it was a place where I got stuck: on your excel sheet, you need to create/set a table for the flow to work (where it asks you to select the 'table' where the row will be added).

[micaashmore]

Thank you Anders, this was super helpful!

[icon.]

Hi Anders...thank you very much for the tutorial...it was very helpful and easy to follow. More Power Automate videos pls!!!

[coollehavre]

Hi Anders, thank you very much, it was helpful and very clear.

[centlivia]

Thanks a lot Anders. Your video was really helpful

[MartineSchmidt]

Ich fand Ihr Video hervorragend: Es ist sehr didaktisch.
Vielen Dank für die Hilfe.

[amyluo]

Really enjoy your presentation! This is the first time that I ever sign in to put a thumbs up!

[IrfanAminChannel]

Thank you Anders! It's much helpful! The one point I was missing is formating as a table in Excel. So, I got that from your reply to a comment. So, the headings of that Excel sheet must be formatted as a table. Hopefully this comment will be helpful for others. Thanks once again!

[neilteago]

Thank you Anders, I was stuck, you helped me out. 😇

[ma.paulatorio]

OMG BADLY NEEEDED THIS TUTORIAL THANK YOUUU!

[max]

Perfect, thank you very much for the video.

[ruthngmj]

this is PERFECT!!
it works for me! thanks alot! :)

[miszngengeh]

Hey Anders! thank you for the useful knowledge! Is there any way that we can compare input from Microsoft forms with excel before adding rows into excel? Thanks!

[starwf]

Helpful video! And some ASMR as an added bonus.

[parthibanbasker]

Hey Anders! thank you for the useful knowledge! Is there any way that we can input from already collected data from Microsoft excel to a forms in office 365? Thanks!

[shrutzin]

Thank you Anders, very helpful. Does this work for responses received from forms pro surveys as well? It seems the license is different for forms and so not able to test this for FormsPro. Also, in FormsPro there is no option of actions on survey response only actions for survey invite...

[motowithbrantley]

Hey there! This was super helpful. I do have a question about a if the form has a required picture. Would you suggest this flow still?

[BrunoAlejBravo]

Hi Anders thank for your tutorial. Do you have any ideas to show the attached files from the forms into the excel cell?