Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Loop not single Items

(0) ShareShare
ReportReport
Posted on by 145

HI

I have an Excel file, and I need to send an email for each 'Course ID' rather than for individual items or values. Additionally, I need to send the email to everybody addresses within the group. In this way all see the recipients

In this case I have to send 3 mail. 

Many thanks

Course IDMailStartEndetcetc
1_AAAttt@gmail.com2024-04-10T09:002024-04-10T11:00  
1_AAAkkk@gmail.com2024-04-10T09:002024-04-10T11:00  
1_AAAwww@gmail.com2024-04-10T09:002024-04-10T11:00  
1_BBBttt@gmail.com2024-04-11T09:002024-04-11T10:00  
1_BBBqqq@gmail.com2024-04-11T09:002024-04-11T10:00  
2_SSSttt@gmail.com2024-04-12T09:002024-04-12T14:00  
2_SSSkkk@gmail.com2024-04-12T09:002024-04-12T14:00  
2_SSSwww@gmail.com2024-04-12T09:002024-04-12T14:00 
  • Garethterb1 Profile Picture
    Garethterb1 106 on at
    Re: Loop not single Items

    I'd suggest that you first build an array variable with only the unique course id's by using a loop with a condition that only adds the course id if it does not exist. Then you can use and apply to each on this variable with the logic to get each email connected to the courser id. So if there are 3 unique course ID's you only send 3 emails.

  • Giorgio67 Profile Picture
    Giorgio67 145 on at
    Re: Loop not single Items

    Hi @Nived_Nambiar 

    I tryed your flow and It's OK about all recipients in TO

    but if "Course ID" have 3 items (one for eatch recipient) the loop send 3 email e 3 meeting teams

    I need to send only one email and only one meeting teams for every eatch "Course ID"

    Giorgio67_0-1712917494683.png

     

    Giorgio67_2-1712917545620.png

    Many Thanks

     

  • Giorgio67 Profile Picture
    Giorgio67 145 on at
    Re: Loop not single Items

    Hi @Nived_Nambiar 

    Thanks again for you help but I have a littel problem yet

     now I have all recipient in TO;It's OK (sent to ttt@gmail.com;kkk@gmail.com;www@gmail.com)💪

    but If I have 3 items in loop For_each, It send 3 mail and 3 invitation Teams ☹️

     

    Giorgio67_0-1712863093400.png

     

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,024 on at
    Re: Loop not single Items

    Hi @Giorgio67 

     

    could you share exacly what you want to acheive here ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • Giorgio67 Profile Picture
    Giorgio67 145 on at
    Re: Loop not single Items

    Yes right Nives

    the column Start and End I'm creating a Teams meeting too

    Thanks

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,024 on at
    Re: Loop not single Items

    Hi @Giorgio67 

     

    so it will be like for course ID 1_AAA  it should be sent to ttt@gmail.com;kkk@gmail.com;www@gmail.com

     

    right ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard