Outlook Emails in Microsoft Power Automate - Beginners Tutorial

This video tutorial shows how to automate Outlook emails with Microsoft Power Automate. You'll learn how to receive emails, save attachments and send dynamic emails. In addition, you learn all the best practices, such as dynamic file naming and data manipulation.

VIDEOS FOR YOU:

POWER AUTOMATE GROUPS:
- Join my network with 4200+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!

FOLLOW ME:

0:00 Preparations
Create a OneDrive (or SharePoint or Dropbox) folder for your attachments.

0:37 Save Attachments When A New Email Arrives
Set up a Power Automate trigger to run whenever you receive a new email with attachment(s). Since an email can have more than one attachment, we use the Apply to each action to iterate through each attachment and save it to OneDrive. After we process the emails, we'll mark them as read and completed. As an advanced feature, we add a dynamic file prefix to the attachment saved.

11:52 Send Dynamic emails
Power Automate is excellent for sending dynamic emails. Based on an Excel sheet, we want to send an email for each Excel row. The content should be dynamic - different email addresses, names, and content.

18:17 Dates in 5-digit format
If you're working with data from Excel online, the dates are in a five-digit format. This number is days after the 30th of December 1899 - I'm not kidding you. So the strategy is to add the days to the 12-30-1899 date, which will get the correct result.

#powerautomate #powerplatform #office365

[andersjensenorg]

Thanks a lot for your comments and support 🙌😊

[senlino]

These moments with date formatting or bugs with writing expressions leave an impression that Microsoft still has a lot to improve with PA. Getting rid of those would avoid unneccesary difficulties and make it more user friendly. The tutorial is great though :)

[bobclarke]

Hi Anders,
Thank you for the superb tutorials. I am no expert but I am learning quickly thanks to your videos and unique relaxed professional teaching style. Your tutorials are really easy to follow.

[nanaampem-darko]

Great video Anders. Keep up the good job

[gokulakannangunasekaran]

Hi Ander, I from India, Its very useful me Thank you so much🙂

[ScottMicale]

would you be able to make a video showing how use this method to get all email addresses from an incoming email and copy all email address and the persons first and last name and populate that into a excel table? Total newbie.

[damodarp]

Hi, very nice thanks a lot. i have one doubt, if the data in excel not formatted as table then how to work on excel file.

[Codingzoe]

Great tips about how the dates work and how to fix it. That would've been confusing otherwise! 👍

[selfhelpandotherfunstuff]

Hey how would you automate tagging and sorting emails for a distribution list of emails to a specific folder /folders in outlook?

[houseofchurch]

Hi Anders, have you ever done a video for power automate where you have certain values formatted post email send? For example what if you wanted all the monetary, date and time values of an email to format to bold and maybe a different color with uso regular expressions in power automate, that way you don’t have to manually format them every email?

[seemaa]

Hi Anders, Thankyou for all the knowledge you are sharing with all of us.
Regarding this video, I have a small doubt -
Consider a situation wherein power automate has stopped running for some reason. But the time the power automate bot starts, it finds multiple emails with attachments in the inbox. In this scenario, will this flow still pick one by one? Or will this flow reads an email as a collection and stores the message ids as collection?
Please help!

[wisdommphande]

Its saving the files in .rpmsg format. How to fix this?

[mayurisarode]

I have one query.
In my case, emails are coming in bulk at the same with the same subject line.
By using subject line I am creating file in eml format.
Due to this my cloud flow is not working.
What should I do in such case.

[venkateshapk]

Hi Anders, hope you are doing well. I would like to understand whether any feasible to track outlook emails who have read our email.

[dladcurlyauthor]

hi Anders.. thank you :) i tried it and worked but suddenly the flow error because all of the variable was disappeared. why? and what the solution

[harmannsagi]

Hi, could you please help me with designing a scheduled flow for automated weekly emails containing tabular information about orders and processing time to my production team ?

[superyellowfirecar]

is it possibe to automate requests so you have your excel sheet with some codes like 123 and and email in the same row and when an outlook email comes in your inbox with a keyword for example "123" power automate recognizes it and sends an email to the email in the excel sheet that has the number 123

[kensleylewis]

Can you do a course on organizing our flows in PA? It would be awesome if we can create something like folders to help organize flows for different purposes, especially when working in a team environment.

[gennarom]

@andersjensenorg WOW Very interesting! How may I add a condition such: If empty homework line in the excel DO not send mail? Thanks!

[whisperienced]

Is it possible to create advanced forwarding rules for instamce forwarding emails from a specific email address with an attachment but not subsequent emails on the same chain?