Unanswered

Loop not single Items

(0) Share

Report

Posted on by Giorgio67

145

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 ID	Mail	Start	End	etc	etc
1_AAA	ttt@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_AAA	kkk@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_AAA	www@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_BBB	ttt@gmail.com	2024-04-11T09:00	2024-04-11T10:00
1_BBB	qqq@gmail.com	2024-04-11T09:00	2024-04-11T10:00
2_SSS	ttt@gmail.com	2024-04-12T09:00	2024-04-12T14:00
2_SSS	kkk@gmail.com	2024-04-12T09:00	2024-04-12T14:00
2_SSS	www@gmail.com	2024-04-12T09:00	2024-04-12T14:00

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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! 🙌

Was this reply helpful? Yes No
Giorgio67 145 on at

Like (0)

Report
Copy link

Link copied!

Yes right Nives
the column Start and End I'm creating a Teams meeting too
Thanks

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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! 🙌

Was this reply helpful? Yes No
Giorgio67 145 on at

Like (0)

Report
Copy link

Link copied!

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 ☹️

Was this reply helpful? Yes No
Giorgio67 145 on at

Like (0)

Report
Copy link

Link copied!

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"

Many Thanks

Was this reply helpful? Yes No
Garethterb1 131 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No