Answered

Unable to send emails one by one with a HTML table

(0) Share

Report

Posted on by CU-20080800-0

I tried to build a flow that reads each row in the SharePoint List, and send the emails to each person row by row. The original SharePoint list has three rows with 3 different persons which have their names, favorite colors and email addresses. I first used "Apply to each values"-->create HTML table-->compose (to format the email) --> send emails to different people, but the result is that there are three rows, but i just want it that each person has one email containing all the information. How to achieve this goal.

Here is my current flow:

Email I'm receiving:

Hope someone can help me!! 😭 This is an assignment due this week.

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Yue_Jiang ,

Please try this

json( concat('[', string( items('Apply_to_each')),']'))

Best Regards,

Wearsky

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

But I find that once I've tried this, I get three separate emails sent to three persons, but I hope that one person receives one email with one HTML table.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Yue_Jiang ,

Have you tried my solution?

Best Regards,

Wearsky

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

Yes, I tried your method, but it turned out my three email addresses each receive three emails, but i hope the first one receives the first row of information, the second one receives the second row... Hope you can help me

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Yue_Jiang ,

But the three pieces of data you provided in the screenshot are the same...

It does send the first record to the first person and the second record to the second person...

Best Regards,

Wearsky

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

Yeah, you are right. It did send the first record to the first person and the second to the second, but three are three rows, I hope i can keep one row for each person.

Was this reply helpful? Yes No
CU-20080800-0 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much, there is some mistake I've sent and I've tried your method, which really worked. Thank you again!

Was this reply helpful? Yes No