Hi @AB21 ,
I have created sample for you.
1. In Power Automate select icon of new flow and then select Scheduled Cloud Flow Trigger.
2. Then use Get Items (Get items Students) Action and apply Filter on Student List for Get Only Today Record.
formatDateTime(utcNow(),'MM-dd-yyyy')
3. Then use Get Items (Get items Staff Member) Action For getting all the staff member.
4. Then use One Compose (Table CSS) Action and Enter CSS Code for HTML Table.
<style>
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 100%;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 13px;
}
table thead {
background: #1C6EA4;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>
5. After That Use One Apply to each Action.
6. Then use Filter Array Action Inside Apply To each.
7. Then Use Create Html Table Action.
item()?['ParentName']
item()?['ParentEmail']
item()?['StudentName']
item()?['StudentYear']
formatDateTime(item()?['Created'],'dd-MM-yyyyTHH:mm')
- After That Use Send an email (v2) Action.
Complete Flow
Student List
Staff member List
--------------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.
