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 - https://youtu.be/omQ-fAF4QpI
🔵 Power Automate Tutorials - https://www.youtube.com/watch?v=kbYGFIo0WGc&list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
Connect with me:
📷 Instagram - https://link.andersjensen.org/instagram/GOFU
👥 Facebook - https://link.andersjensen.org/facebook/SoC
🎮 Discord - https://discord.gg/d8KQpTUvFD
💼 LinkedIn - https://link.andersjensen.org/linkedin/eISB
💌 Email Newsletter - https://andersjensen.org/email-newsletter
🕊️ Twitter - https://link.andersjensen.org/twitter/f_bh
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
Видео Microsoft Power Automate - How to get Forms responses to Excel and Email - Full Tutorial канала Anders Jensen
You could also watch:
🔵 Power Automate For Beginners - https://youtu.be/omQ-fAF4QpI
🔵 Power Automate Tutorials - https://www.youtube.com/watch?v=kbYGFIo0WGc&list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
Connect with me:
📷 Instagram - https://link.andersjensen.org/instagram/GOFU
👥 Facebook - https://link.andersjensen.org/facebook/SoC
🎮 Discord - https://discord.gg/d8KQpTUvFD
💼 LinkedIn - https://link.andersjensen.org/linkedin/eISB
💌 Email Newsletter - https://andersjensen.org/email-newsletter
🕊️ Twitter - https://link.andersjensen.org/twitter/f_bh
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
Видео Microsoft Power Automate - How to get Forms responses to Excel and Email - Full Tutorial канала Anders Jensen
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Setup a Holiday Approval Flow with MS Forms, Planner & Flow | Microsoft 365](https://i.ytimg.com/vi/1ugiG_XgLvQ/default.jpg)
![Power Automate Microsoft Forms Connector tutorial with Attachments](https://i.ytimg.com/vi/kbqXsKPTmZk/default.jpg)
![Properly Create Surveys with Microsoft Forms & Export to Excel](https://i.ytimg.com/vi/nXeYv-W-Wt4/default.jpg)
![Collect Data into Excel Online | Forms, Surveys, Questionnaires using Office 365](https://i.ytimg.com/vi/tztzXo5TXpE/default.jpg)
![Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new features](https://i.ytimg.com/vi/8O68-cc-QNo/default.jpg)
![🤖 How to use Microsoft Power Automate Desktop - Full tutorial](https://i.ytimg.com/vi/IQ_KpBC8fwo/default.jpg)
![](https://i.ytimg.com/vi/i9RetTU_X2o/default.jpg)
![How To Send Microsoft Forms Responses to Multiple Email Ids using Power Automate](https://i.ytimg.com/vi/pMq4o6LurEQ/default.jpg)
![Send Emails from Excel with Power Automate](https://i.ytimg.com/vi/vg4NmlscoFU/default.jpg)
![Send Email Notification with Form Response Details](https://i.ytimg.com/vi/Oyn4OW1Mi_E/default.jpg)
![How to Capture Form Responses in an email with Flow](https://i.ytimg.com/vi/HsehcCNGxBI/default.jpg)
![Power Automate Submit MicroSoft Forms Responses to Excel Online](https://i.ytimg.com/vi/CZ3ViZ-XrF8/default.jpg)
![Top 25 Microsoft Forms tips and tricks for 2021 // New features, hidden gems & Office integration](https://i.ytimg.com/vi/wtQbMdqXjxQ/default.jpg)
![👩💻 How to use Office Scripts in Excel & Power Automate](https://i.ytimg.com/vi/il7YS7Dx228/default.jpg)
![Create Simple Document Approval Flows using Power Automate & SharePoint](https://i.ytimg.com/vi/ruu7UJE0KPk/default.jpg)
![Easy Excel Forms - No VBA & access from any device!](https://i.ytimg.com/vi/Eys3YTmtK2s/default.jpg)
![How to Automatically Import Microsoft Forms Responses to Power BI](https://i.ytimg.com/vi/b1TOFi1F-vc/default.jpg)
![Learn to Use Power Automate with Examples | Create Bulk PDF Files | Planner to Outlook](https://i.ytimg.com/vi/SUsik0FGzI0/default.jpg)
![How to compare Excel Tables/Sheets in Microsoft Power Automate](https://i.ytimg.com/vi/CRJXfVVhYrA/default.jpg)
![Save Microsoft Forms Attachments to SharePoint with Power Automate](https://i.ytimg.com/vi/Xb_k8vOERpU/default.jpg)