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

[TMMK64571]

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>

[efialttes]

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]

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.

[efialttes · Accepted solution]

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]

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]

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!