Help needed ! with email and tables for specific people

(0) Share

Report

Posted on by Dan97

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

SAMPLE.xlsx

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No