Скачать или смотреть 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:
🔵 Power Automate For Beginners -    • Microsoft Power Automate Tutorial for Begi...  
🔵 Power Automate Tutorials -    • Microsoft Power Automate | Add data to Exc...  

FOLLOW ME:
💼 LinkedIn:   / andersjensenorg  
🐦 Twitter:   / andersjensenorg  
📸 Instagram:   / andersjensenorg  
👨 Facebook:   / andersjensenorg  
👨‍👩‍👧‍👦 Discord:   / discord  
💌 Email Newsletter: https://andersjensen.org/email-newsle...

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