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 ID | 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 |
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.
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
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 ☹️
Hi @Giorgio67
could you share exacly what you want to acheive here ?
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! 🙌
Yes right Nives
the column Start and End I'm creating a Teams meeting too
Thanks
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 ?
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! 🙌