Import Outlook to Excel with Power Automate Tutorial
🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to import email from either Gmail or Outlook into Microsoft Excel using Power Automate. First, we visit Office.com and sign in with a free account. Next, we set up a new workbook in Microsoft Excel and enter the columns that we want to populate with content from an email. We proceed to Power Automate, where we set up a flow to take the contents of an email and insert them into our workbook table. Finally, we test the flow to ensure that the email successfully imports into the Excel worksheet. By the end, you'll be able to take the contents from an email and fill it into your Excel workbook. The resulting flow will work automatically in the cloud and there's no need to launch Outlook, Gmail, or Excel for this to work.
👋 Additional resources
- How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw
- Reference guide to using functions in expressions for Power Automate - this will help you understand the expressions below and how they parse text in an email: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
- The expression in the "Cookie Type" field:
first(skip(split(first(split(body('Html_to_text'),'Quantity')),': '),1))
- The expression in the "Quantity" field:
first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))
- The expression in the "Delivery Method" field:
first(skip(split(body('Html_to_text'),'Delivery Method: '),1))
⌚ Timestamps
0:00 Introduction
0:56 Sign into office.com
1:28 Create new Excel workbook
3:07 Navigate to Power Automate
4:02 Build automated cloud flow
5:15 Example email to import into Excel
5:39 Step 1: Check when a new email arrives & filters
6:35 Step 2: Convert HTML into text
7:20 Step 3: Add new row into Excel table with email contents
9:55 Extract content from body of email using expression
11:28 Test flow
13:05 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Power Automate: https://youtube.com/playlist?list=PLlKpQrBME6xKE_fxQ_YzHVV7HluHpifW9
- Playlist with all my videos on Outlook: https://youtube.com/playlist?list=PLlKpQrBME6xJswJLJ69wbWWf6QlwZ84nA
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео Import Outlook to Excel with Power Automate Tutorial канала Kevin Stratvert
In this step-by-step tutorial, learn how to import email from either Gmail or Outlook into Microsoft Excel using Power Automate. First, we visit Office.com and sign in with a free account. Next, we set up a new workbook in Microsoft Excel and enter the columns that we want to populate with content from an email. We proceed to Power Automate, where we set up a flow to take the contents of an email and insert them into our workbook table. Finally, we test the flow to ensure that the email successfully imports into the Excel worksheet. By the end, you'll be able to take the contents from an email and fill it into your Excel workbook. The resulting flow will work automatically in the cloud and there's no need to launch Outlook, Gmail, or Excel for this to work.
👋 Additional resources
- How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw
- Reference guide to using functions in expressions for Power Automate - this will help you understand the expressions below and how they parse text in an email: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
- The expression in the "Cookie Type" field:
first(skip(split(first(split(body('Html_to_text'),'Quantity')),': '),1))
- The expression in the "Quantity" field:
first(skip(split(first(split(body('Html_to_text'),'Delivery Method')),'Quantity: '),1))
- The expression in the "Delivery Method" field:
first(skip(split(body('Html_to_text'),'Delivery Method: '),1))
⌚ Timestamps
0:00 Introduction
0:56 Sign into office.com
1:28 Create new Excel workbook
3:07 Navigate to Power Automate
4:02 Build automated cloud flow
5:15 Example email to import into Excel
5:39 Step 1: Check when a new email arrives & filters
6:35 Step 2: Convert HTML into text
7:20 Step 3: Add new row into Excel table with email contents
9:55 Extract content from body of email using expression
11:28 Test flow
13:05 Wrap up
📃 Watch related playlists
- Playlist with all my videos on Power Automate: https://youtube.com/playlist?list=PLlKpQrBME6xKE_fxQ_YzHVV7HluHpifW9
- Playlist with all my videos on Outlook: https://youtube.com/playlist?list=PLlKpQrBME6xJswJLJ69wbWWf6QlwZ84nA
- Playlist with all my videos on Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
🚩 Connect with me on social
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
🔔 Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
🛍 Support me with your Amazon purchases: https://amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
Видео Import Outlook to Excel with Power Automate Tutorial канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
PIRATES Invade SeattleMunich, Germany | Stunning GoPro Video TourBermuda Family VacationOur family visits Oahu!How to use Presenter View in Microsoft TeamsUplevel your PowerPoint game with MORPHYou've Been Presenting PowerPoint Wrong…5 Mind-blowing AI Tools 🤯Best Excel Shortcuts in under 1 min🔥 CapCut Video Editing Tips and TricksHow to use Microsoft Power Query🧙♂️ 5 BEST Shortcuts in Microsoft WordPower Virtual Agents Chatbot TutorialTop 5 Most Useful Websites5 Mind-blowing Artificial Intelligence Tools 🤯🎬 BEST CapCut Video Editing Tips and TricksHow to Use Cameo in PowerPoint5 PowerPoint Secrets Exposed! 🤫Google Drive Tips and TricksHow to use PowerPoint CameoOBS Studio Tips and Tricks