Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Unable to send emails one by one with a HTML table

(0) ShareShare
ReportReport
Posted on by

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: 

Yue_Jiang_3-1709258090581.png

Yue_Jiang_4-1709258104375.png

Email I'm receiving: Yue_Jiang_2-1709258029864.png

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

 

 

 

  • Re: Unable to send emails one by one with a HTML table

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

  • Re: Unable to send emails one by one with a HTML table

    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.

  • Re: Unable to send emails one by one with a HTML table

    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...

    vxiaochenmsft_0-1709272894985.png

     

    Best Regards,

    Wearsky

  • Re: Unable to send emails one by one with a HTML table

    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

    Yue_Jiang_0-1709272680139.png

     

  • Re: Unable to send emails one by one with a HTML table

    Hi @Yue_Jiang ,

     

    Have you tried my solution?

     

    Best Regards,

    Wearsky

  • Re: Unable to send emails one by one with a HTML table

    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. 

  • Verified answer
    Re: Unable to send emails one by one with a HTML table

    Hi @Yue_Jiang ,

     

    Please try this

    vxiaochenmsft_0-1709258920194.png

    json( concat('[', string( items('Apply_to_each')),']'))
     
    Best Regards,
    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics