
Announcements
Hi everyone ! I am still quite new to power automate and would like to seek help in terms of sending emails with tables to specific people . can someone guide me in terms of solving my problem?
Attached is the raw file as sample data
Sample of how i want the email to look:
for Customer "1234" I want it to look like this and sent to "John3@email.com" (all the other customers are similar in terms of the email)
Hi "John"
Attached below is the status requested :
| Customer | Customer name | Amount | CL |
| 1234 | John | 1000 | 6000 |
This is an automated reply
Hi @Dan97 ,
Are you like sending an email with a form?
You can try to create a custom HTML table in compose.
<table border="1" style=border-collapse:collapse>
<tr>
<th>Customer</th>
<th>Customer name</th>
<th>Amount</th>
<th>CL</th>
</tr>
<tr>
<td>@{items('Apply_to_each')?['Customer']}</td>
<td>@{items('Apply_to_each')?['Customer name']}</td>
<td>@{items('Apply_to_each')?['Amount']}</td>
<td>@{items('Apply_to_each')?['CL']}</td>
</tr>
</table>
Best Regards,
Dezhi