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:
