Skip to main content
Community site session details

Community site session details

Session Id : oNeJPdQZJ4HL6RoykQ+zno
Power Automate - Using Connectors
Answered

Unable to send emails one by one with a HTML table

Like (0) ShareShare
ReportReport
Posted on 1 Mar 2024 01:58:52 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.

 

 

 

  • CU-20080800-0 Profile Picture
    on 01 Mar 2024 at 12:43:20
    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!

  • CU-20080800-0 Profile Picture
    on 01 Mar 2024 at 11:33:51
    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.

  • v-xiaochen-msft Profile Picture
    on 01 Mar 2024 at 06:03:18
    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

  • CU-20080800-0 Profile Picture
    on 01 Mar 2024 at 05:58:38
    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

     

  • v-xiaochen-msft Profile Picture
    on 01 Mar 2024 at 05:55:25
    Re: Unable to send emails one by one with a HTML table

    Hi @Yue_Jiang ,

     

    Have you tried my solution?

     

    Best Regards,

    Wearsky

  • CU-20080800-0 Profile Picture
    on 01 Mar 2024 at 05:38:10
    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
    v-xiaochen-msft Profile Picture
    on 01 Mar 2024 at 02:08:52
    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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Loading complete