How to Automate Getting Your Daily Outlook Calendar Summaries with Power Automate
✨ Rachel Irabor
DevRel | Microsoft MVP | Global Public Speaker | Technology Evangelist | Ethical AI Advocate
I came cross a question online from someone looking to automate the process of receiving a summary of their calendar events every day at 8:00 AM. I created a Power Automate flow to solve this and shared the solution with them, but I realized others might be searching for the same thing. I decided to write a quick blog post to walk through how to set this up step by step, so here I am.
Step-by-Step Process
Start by creating the flow as a Scheduled cloud flow. Set the frequency to Day, the interval to 1, and choose your desired start time. for example, 8:00 AM
Add the "Initialize variable" action:
Name: CalendarSummary
Type: String
Value: Leave this empty
Add the action "Get calendar view of events (V3)". This action will retrieve all calendar events for the current day.
Configure it as follows:
Calendar ID: Select the Outlook calendar you want to use.
Start Time: Use the expression:
End Time: Use the expression:
After the Get calendar view of events (V3) action, add an Apply to each action.
In "Select an output from previous steps", choose value from the dynamic content. This value represents the list of events returned by the calendar action.
Inside the Apply to each action, add the Append to string variable action.
Name: Select the CalendarSummary variable you initialized earlier.
Value: This is where you define what details you want to include in the summary. Here’s an example:
Outside the loop (after the Apply to each), add the Send an email (V2) action.
To: Enter your own email address.
Subject: Something like "Today's Outlook Calendar Summary".
Body: In the dynamic content, select the append to string variable. This will include all the event details you compiled.
Note: If you don’t like the default format of the start and end times, you can adjust the format using an expression.
Thank you for reading!
Please subscribe to my YouTube channel, thank you!!
Systems Admin
2w✨ Rachel Irabor Thanks for this, just what I needed. I made a few additions/changes. 1. In the "Recurrence" action I put the Eastern Time zone in the "Time zone" field. In the "At these hours" field I put in 6 for 6 am. 2. My "Get calendar view of events (V3)" was like yours. Except for I am sending out reminders to coworkers days in advance about certain meetings. I used startOfDay(addDays(utcNow(), 91)) and startOfDay(addDays(utcNow(), 92)) for "Start Time" and "End Time" fields. I also added the name of meeting in the "Search" field. 3. I added the "Initialize variable" action after "Get calendar view of events (V3)" just like yours. 4. My "Apply to each" action was like yours except for "Start time" I just only wanted the date so I used "formatDateTime(items('Apply_to_each')?['start'], 'MM-dd-yyyy')" and typed in the time to hard code. I added the <br> code to the beginning AND end of each line so it would format double spaced. Extra lines between the lines is easier on the eyes in Power Automate and in an email. Left extra <br> breaks in place. Screen shot attached. 5. My "Send an email (V2)" action is the same as yours.
Product Development Consultant @ Murex | Enterprise Risk Management
1moNice explanation!
Information Security Officer | Enterprise Security at Sanlam Kenya
2mogreat article
🏆 Microsoft 365 | Copilot (Studio) | AI | PowerPlatform | Agile | bij Gemeente Zwolle
2moThis could also be done using Copilot Studio or just Copilot
PowerPlatform Developer
2moI just have to keep the screenshot for future use. This would come in handy. Thank you so much!