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 Automate
Answered

Mapping emails

(0) ShareShare
ReportReport
Posted on by 27

power automate on getting items from the SharePoint list that has name and email fields from the SharePoint list and compose an email with all the email fields in to column of email. In the list there are 12 people who has their email in the list. I want to get all the emails and send one email to all the people from shared mailbox.

Note: I want one email to send to all people

Categories:
I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @gurleenm 

     

    For demo purposes i have created a sample sharepoint list which has Name and EmailID of persons whom email need to be sent like below

    Nived_Nambiar_0-1692378278434.png

     

    Now the flow should be designed like below:

     

    Step1: Use Get items to retrive Items from SharePoint List

    Nived_Nambiar_1-1692379023078.png

     

     

    Step2: To get the list of email ids from the sharepoint list as an array, use select action to select EmailID from values dynamic content like below

    Nived_Nambiar_2-1692379077868.png

     

     

    Step 3:  To Join the email ids with ; , as the semicolon is used as delimiter for sending single email to multiple person at same use Join action to join the array obtained from Step2 with ; delimiter like below.

    Nived_Nambiar_3-1692379239877.png

     

     

    Step 4: Now use send email action email from Shared email Box like below 

    Nived_Nambiar_4-1692379289028.png

     

     

     

    Hope this helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

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

  • Verified answer
    gurleenm Profile Picture
    27 on at

    I got this error

    gurleenm_3-1692380424768.png

     

    gurleenm_4-1692380485112.png

     

     

     

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @gurleenm 

     

    It seems like the datatype of your email column is not string as i have used string datatype for email column in ,my answer.

     

    Could you confirm what is the datatype of column you have used there ?

     

  • gurleenm Profile Picture
    27 on at

    Thank you! 

    It worked

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @gurleenm 

     

    Kindly mark the correct answer as solution so that it help others 🙂

     

     

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard