Outlook Emails in Power Automate Desktop - Full Tutorial

This full video tutorial shows how to use the Outlook email actions in Microsoft Power Automate Desktop.

VIDEOS FOR YOU:

POWER AUTOMATE DESKTOP GROUPS:
- 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!

FOLLOW ME:

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

[andersjensenorg]

Please give the video a thumbs up if it helped you.
Thank you 🙌😊

[kristophwhidden]

This is a great tutorial! When I attempt to use the variables produced (for example '.Subject')from the 'Retrieve email messages from Outlook', I am not given the option to expand the email items, such as '.Attachments', '.Bcc', '.Body', etc. Any idea what might be causing this? Thanks in advance Anders!

[SeabrookEnt]

This is the only video I could find that shows how to use the desktop version of Power Automate - Great video!

[GallaxyCreator]

Hello, what version of PAD did you use in this video? I cannot insert a row in Excel the way you do, and that is why my flow does not perform as intended. Thank you.

[mrphelps]

Thank you for this nice video. Please How can I retrieve a table that is in the body of the mail ?

[prasenjitmandal]

Hi Anders ! I hope, You are doing.
Could you please suggest. How we can interact Shared outlook mail box by Power Automate Desktop.

As I am trying at my end by Power Automate Desktop. However, Unable to resolve.

[goodluckfox]

Anders, you have saved my bacon. I am overloaded with cases already, and we just lost the only other attorney in my department, and all her cases have been assigned to me. My IT guys sent out 300 docusign emails, but when they came back, I had 300 emails with no identifying information in them, and 300 each of Attachment1, Attachment2, Attachment3, and Attachment4 (with no external indication of who the client was.) Thanks to you, I was able to iterate through the mail, extract the data from the PDF attachments to identify the client and re-save the attachments with the client name catted to them, and then do real work. What would have been a two week project was done in a day. Thank you. THANK YOU. I have now subscribed to your channel and I plan on following along on ALL your tutorials.

[JuanDry-iz]

Thanks for the video but can you help me for the course material cause i cant download from your website. The website can't be reach. Thank you

[Robin]

Hi Anders,
Thanks for the great video.
I did find a few problems which I have managed to solve, but they may have affected other subscribers. So here are the problem and solution:
1) I am using an IMAP outlook account. This did not retrieve emails until we set the Retrieve email path to Inbox/PAD The backslash did not work.
2) The email retrieval crashed and only did one mail.
Solution: I found the email from Stine Høiberg Rasmussen, which caused the problem because of the special character in his name.

Where could I get the instructions on how to Scrap information from the body text. I do not need the entire text only specific information. All the Body Texts have the exact same layout with only the person's name and number changing.
I will post this on Discord as well. :)

[ngocnguyen]

Hi Anders. Thanks so much for you video. I practiced as your video. However, in case 2 emails have some attachments with the same name. It auto created number file name at the end . So, is there any way to handle it?

[SandroMochiaro]

Hi Anders, congratulations on the video. A suggestion would be to rename the file with an increment (name + 1) or with the date (hour, minute and second) to gather all the attachments in the same folder.

[christievthomas]

Is it possible to read 1 email at a time in PAD?

[marcobacchetti]

Hi Anders and thanks a lot for your amazing videos! I'm learning a lot!

I have an issue opening the Emails file after the robot runs: Excel starts but it appears blank and no data is displayed.
The file preview is available and I can see here it worked properly.
If I try to let I work again it stops when opening the file.
Same issue with the Excel files created after WEB Scraping Data from Amazon

Any idea what is wrong with them?

[GalinaT]

To save attachments from emails retrieved in Outlook using Power Automate but exclude saving .jpeg attachments?

[NickRoss]

Everything is running smoothly, but when I try to open up the excel document with the information it opens up but Everything is blank. Like I see all the tabs like file, home, insert, etc... but it's just white nothingness under it.

[yedhosodhi]

I tried with TO address. Getting an error

[Vijay_Vloggs]

It's really helpful to my daily tasks... Also Please do the session on database automation on PAD.. Love u Always❤❤❤Thanks in advance !!!

[PitakYT]

Thank you so much, This is excellent videos. I'm learning a lot from your channel. 👍👍👍🙏🙏🙏

[frumanvlogs]

Hi. How should I extract specific information in the body of the email?

[Robin]

Hi Anders
Thank you for all of your excellent videos.
Do you have a video to show how to extract specific information from the "body" text of the email?
The email has content in it such as the client's Name and a customer number. I would like to place that in the excel file in a separate column.
Appreciate your help.