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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Longshot: Get string o...
Power Automate
Answered

Longshot: Get string of emails from SharePoint, open Outlook to create Unique email content

(0) ShareShare
ReportReport
Posted on by 55

I have created flows that will send an email when a row is created in SharePoint by collecting emails from another list.  But that is a standard format and I need a more unique solution for a new problem.  I have an employee resource group that is a mix of people with members with organizational email and personal email.  I would like to collect those from a SharePoint List and open Outlook email so that the body could be created uniquely.  Any suggestions?  <Fingers crossed>

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

    "I have an employee resource group that is a mix of people with members with organizational email and personal email. I would like to collect those from a SharePoint List and open Outlook email so that the body could be created uniquely. Any suggestions?"

     

    Can you share a screenshot of your current Sharepoint list definition, and some examples describing which columns, tems etc you wish to collect ? Also if you can specify a little bit email body structure expected

    THanx

  • TMMK64571 Profile Picture
    55 on at

    No.  This does not yet exist.  I do not want to put in the effort to build it out if this is not possible.

     

    I will have a SharePoint list that just has an email for each member, and possibly their full name as a secondary field.  The email going out will vary each time, announcing either an activity that members can participate in like Habitat for Humanity or a Health Fair as examples.  This is why the flow needs to create the email string, open Outlook and copy it into the To: field and then whomever will create the body contents.

  • Verified answer
    efialttes Profile Picture
    14,756 on at

    Hi

    So if your current Sharepoint list stores email address and Full Name, you can implement a flow that will send one independent email per sharepoint item, meaning each target email address will receive its own email. You can add in the body Dear <full name> so you customize its contents also.

     

    "The email going out will vary each time, announcing either an activity that members can participate in like Habitat for Humanity or a Health Fair as examples. "

    So, either each person in your list has a preferred activity list associated, or you suggest then activities in a random way... you will probably need to have a second Sharepoint list with activities name, details etc. so you do not need to modify your flow everytime you want to add a new event.

     

    Happy flowing!

  • TMMK64571 Profile Picture
    55 on at

    I think I may be able to work with this, (PowerApp needed seems like), but I am curious how you would format the body, and how you would put the signature at the end.  Would the signature be stored in yet another list as an image perhaps?

  • efialttes Profile Picture
    14,756 on at

    Hi!

    As far as I know, Power Automate cannot embed images in email bodys yet

     

    But, you can easily add outputs from other action blocks to your email body, also variables

    You can also add HTML code.

     

    My suggestion is just to try it. THere are thousands of examples in this community, also videotutorials etc.

    Happy flowing!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard