Request for Assistance: Creating a Weekly Summary Email in Power Automate

[kleber1976]

Hello colleagues,

I'm facing a challenge with my Power Automate flow and need your assistance.

How can I create a flow to send just one email per week that consolidates all the changes to my appointments and meetings from my Outlook calendar? I want to avoid sending multiple emails throughout the week for each change, as this could overwhelm recipients and reduce their interest in the updates.

Ideally, I'd like to send a single email at the end of the week summarizing all the changes. Can anyone help me with this challenge?

Thanks in advance.

[David_MA]

Build your flow with these actions:

The Start Time expression for the Get calendar view of events is:

addDays(startOfDay(utcNow()),-1)

The End Time expression for the Get calendar view of events is:

addDays(startOfDay(utcNow()),6)

Note, the above expressions will get the events for the current week based on running the flow on Mondays. Adjust accordingly if you schedule it a different day.

The Start expression for the date in the Select action is:

formatDateTime(convertTimeZone(item()?['start'], 'UTC', 'Eastern Standard Time'), 'M/dd/yyyy h:mm tt')

The End expression for the date in the Select action is:

formatDateTime(convertTimeZone(item()?['end'], 'UTC', 'Eastern Standard Time'), 'M/dd/yyyy h:mm tt')

Adjust for your time zone.

Then just put the output of the Create HTML table action into your e-mail action. You will want to put it in HTML mode and add some styling to format the table. I use this CSS:

<style>
Table {
  font-family: Arial, Helvetica, sans-serif;
  background-color: ; #EDF0F2;
  border-collapse: collapse;
  width: 100%;
  max-width: 820px;
}
Table td, Table th {
  border: 1px solid #ddd;
  padding: 3px 3px;
}
Table th {
  font-size: 15px;
  font-weight: bold;
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: left;
  background-color: #0038A6;
  color: white;
}
</style>

Which returns:

[kleber1976 · Accepted solution]

Hello @David_MA,

Thank you very much for your support!

The solution isn't working completely as I'm encountering an issue. Specifically, I want to set up an automated email that I and the participants of the meetings/schedule appointments receive every Friday just if some change has happened in the shared calendar. This email should list appoitments that only has changed to my Outlook shared calendar throughout the year. Given that I have in this hared calendar numerous appointments and schedules calls/meetings throughout the year, these often undergo changes. I would like this email to update participants about only those appointments or schedules that have been modified, rather than every single event or the entire week’s schedule. Just if is possible for you could you please provide further assistance or another tip to achieve this? Thanks in advance!

[David_MA]

What you describe is not anything I have needed to do, so I cannot answer your question. I think there is a trigger action when an event is updated, but since it is a trigger action I don't know how you would store the changes until Friday. Good luck. Why don't you just use the built-in notification feature of Outlook when you update the calendar event?