Answered

Send an HTML table group mail from an excel table

(0) Share

Report

Posted on by Community Power Pla...

I am searching for months a flow that allows me to send an html table with several rows to an email.

For example I have this excel table in One Drive.

Process	Code	Owner	Owner Mail
Process 1	Code 1	Cristiano Ronaldo	cristiano@mail.com
Process 2	Code 2	Messi	messi@mail.com
Process 3	Code 3	Messi	messi@mail.com
Process 4	Code 4	Neymar	neymar@mail.com
Process 5	Code 5	Neymar	neymar@mail.com
Process 6	Code 6	Cristiano Ronaldo	cristiano@mail.com
Process 7	Code 7	Cristiano Ronaldo	cristiano@mail.com
Process 8	Code 8	Neymar	neymar@mail.com
Process 9	Code 9	Neymar	neymar@mail.com

-I manually trigger the flow

2-Get the rows from the One Drive Excel File

3-I Create the hmtl table, and selelect the columns: Process, code, owner

4-Then create the email: I put to send the "Owner mail" an in the body the html table.

But for example Cristiano Ronaldo receives 3 diferent mails(One table with a row per register), and that makes the receiver uncomfortable.

In the case of Cristiano Ronaldo, I hope he receive this table:

Process	Code	Owner
Process 1	Code 1	Cristiano Ronaldo
Process 6	Code 6	Cristiano Ronaldo
Process 7	Code 7	Cristiano Ronaldo

Can you help me please.

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

Hello @v-bacao-msft
I had the same task similar to the problem, I am new to Power Automate
Thanks to your post, I followed you post it was helpful.

But i am stuck at a point where i receive an error, i am very unclear how to correct the error. can you please help me.

The error i receive is " Unable to process template language expressions for action 'Apply_to_each_2' at line '1' and column '15394': 'The template function 'variable' is not defined or not valid.'. "

Thanks
Karthik
v-bacao-msft on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

Hi @Anonymous ,

If you want to refer to current item, the corresponding action needs to be configured in Apply to each.

Please take a closer look at the screenshot I provided, pay attention to the name of Apply to each, and when choosing Current item, you need to pay attention to which Apply to each comes from.

Please try again.

Best Regards,
Community Power Pla... on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

@

@v-bacao-msft What can be this error?
v-bacao-msft on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

Hi @Anonymous ,

Please check this thread again:

https://powerusers.microsoft.com/t5/Building-Flows/Sending-Scheduled-Emails-with-Excel-Rows-Included/m-p/593729#

Best Regards,
Community Power Pla... on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

Hi @v-bacao-msft
Thank you for helping me.

I was reading the similiar question and I have a doubt .Can you help me. What I have to put on Apply to ech 3?
Verified answer

v-bacao-msft on at

Like (0)

Report

Re: Send an HTML table group mail from an excel table

Hi @Anonymous ,

Please refer to this similar thread and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/Sending-Scheduled-Emails-with-Excel-Rows-Included/m-p/593729#

Feel free to let us know if you have any other questions.

Best Regards,