web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to send properly e...
Power Automate
Answered

How to send properly email in TO and CC sections using power automate?

(0) ShareShare
ReportReport
Posted on by 127

I have a sharepoint list with column emails and ccemails.

I want to send email every week.

emails and ccemails are multi select person column fields.

emailsccemails

Helen Hagos

Selam Gere

Kidist John

Mike Asmare

I use the following flows

Sebey_0-1689284453244.png

this flow send emails but the number of emails are not correct, it is repeating emails.

1st email:

To: Helen Hagos

cc:Kidist John

2nd email:

to:Helen Hagos

cc:Mike Asmare

3rd email:

to: selam Gere

cc:Kidist John

4th email: 

to: selam gere

cc:Mike Asmare

===========

my expectation was:

to: helen john

    selam gere

cc: kidist John

    Mike Asmare

================i tried to put semicolen at the end of the emails in the to and cc part, it doenot work, but I noted that the problem is with loops because the email works fine but wrongly looped.

In the Apply to each 2 and Apply to each 3, if I changed the place of  emails and ccemails, the problem is similar, If I replace them with Current item, it doesnt work the email.

how can I  solve this problem:

 

Categories:
I have the same question (0)
  • Verified answer
    TanyaMc365 Profile Picture
    63 on at

    You need to use variables for to and cc and then append them as you loop through the column. 

     

    This link isn't exactly your scenario but should help, just remember you need two variables/loops.

    https://www.c-sharpcorner.com/article/power-automate-send-email-to-multiple-values-in-people-picker-field-in-sharepoin/

  • Sebey Profile Picture
    127 on at

    I modify it by using variables , and working fine. Here is the screen shoot.

    Sebey_0-1689331412301.png

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard