Yes, You can follow below steps to do:
#1. First, I used a Select action to pull just the organiser email addresses from the calendar events.
#2. Then, Add Compose action and write below expression find the unique organizer. It will give the list of unique organizer.
union(body('Select'),body('Select'))
#3. Then, Add an Apply to each on the output of that Compose action.
#4. Add Filter Array action.
#5. After that, Add Create HTML table action to format the bookings, mapping only the columns I wanted in the email (like subject, start/end time, and location).
#6. Add Send an email (V2) action, set it to HTML, and included the table in the body.
To: Write below action in expresssion:
<html>
<head>
<style>
table {
border-collapse: collapse;
width: 100%;
font-family: Segoe UI, Arial, sans-serif;
font-size: 13px;
}
th {
background-color: #f3f2f1;
color: #323130;
text-align: left;
padding: 8px;
border: 1px solid #d2d0ce;
}
td {
padding: 8px;
border: 1px solid #d2d0ce;
}
tr:nth-child(even) {
background-color: #faf9f8;
}
tr:hover {
background-color: #edebe9;
}
</style>
</head>
<body>
<p>Hello,</p>
<p>Please review the following room bookings for today and cancel any that are no longer required:</p>
@{outputs('Create_HTML_table')}
<p>Thank you.</p>
</body>
</html>
All Actions:
If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.
---------------------------------------------------------------------------------
📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!
