Outlook Emails in Power Automate Desktop - Full Tutorial

Anders Jensen โ€ข October 4, 2022
Video Thumbnail

About

No channel description available.

Video Description

This full video tutorial shows how to use the Outlook email actions in Microsoft Power Automate Desktop. ๐Ÿ“‚ Course Materials: https://andersjensen.org/microsoft-power-automate-desktop/outlook-emails VIDEOS FOR YOU: ๐Ÿ”น Full Power Automate for Desktop Course: https://youtube.com/playlist?list=PLX... ๐Ÿ”น My RPA Developer Salary: https://youtu.be/KDaTZDo8LVM POWER AUTOMATE DESKTOP GROUPS: ๐Ÿ‘จโ€๐Ÿ‘ฉโ€๐Ÿ‘งโ€๐Ÿ‘ฆ Discord: https://discord.gg/iloveautomation - Join my network with 4000+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free! ๐Ÿ‘ฉ๐Ÿปโ€๐ŸŽ“ LinkedIn: https://www.linkedin.com/groups/12566435 ๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป Facebook: https://www.facebook.com/groups/754059285247921 FOLLOW ME: ๐Ÿ’ผ LinkedIn: https://www.linkedin.com/in/andersjensenorg ๐Ÿ“ธ Instagram: https://www.instagram.com/andersjensenorg ๐Ÿ‘จ Facebook: https://www.facebook.com/andersjensenorg ๐Ÿฆ Twitter: https://twitter.com/andersjensenorg ๐Ÿ’Œ Email Newsletter: https://andersjensen.org/email-newsletter 0:00 Prepare Data Automating Outlook emails with Microsoft Power Automate Desktop is straightforward. First, download the course materials: Five sample emails and an Excel book. Then, place the sample emails in an Outlook subfolder. 3:16 Retrieve Email Messages From Outlook In the Retrieve email messages from Outlook action, we specify an account (the data file name) and a mail folder. This will get us a list of Outlook mail messages. Here we can also select if we want to save attachments. 6:47 Extract Outlook Emails Use a For each to iterate through the list of Outlook mail messages. Create a Data Table. A Data Table is a collection of DataRows. For each email, we add a DataRow into the Data Table with the extracted information. Finally, write the Data Table on an Excel sheet. 22:00 Save Multiple Outlook Email Attachments We create an If that finds out whether or not we have an attachment(s) to each email. If yes, we want to save the attachment with Power Automate Desktop. We move the attachment to a folder with a unique ID (the entry ID of the email). #powerautomate #powerplatform #office365