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.
Thank you so much, there is some mistake I've sent and I've tried your method, which really worked. Thank you again!
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.
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
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
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.
Hi @Yue_Jiang ,
Please try this