This video guide 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.
📂 Download the course materials: https://andersjensen.org/microsoft-power-automate/outlook
VIDEOS FOR YOU:
🔹 Microsoft Power Automate Beginner Course: https://youtube.com/playlist?list=PLXXz88_TPiHqGlJoWhBDCAxZ9m1N_jsB6
🔹 Use AI in your Power Automate flows: https://youtu.be/Y8WrwVdMiJg
POWER AUTOMATE GROUPS:
👨👩👧👦 Discord: https://discord.gg/iloveautomation
– 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!
👩🏻🎓 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://and
ersjensen.org/email-newsletter
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
