Attaching and embedding photos to email from SharePoint Library

[csbassplayer200]

Hello,

I am in the process of creating a flow that triggers from Sharepoint. When certain updates are made, it will trigger an automated email that houses information as well as photos that are stored in a Sharepoint library related to that entry. I have everything working, but i have ran in to a weird snag that i dont understand:  I am attempting to both attach the photos to email, and embed the photos in the email (various departments use either the embeds or attachments, so both are useful). I can get one or the other to work, but not both and im not sure why. (Screenshots below)

When the 'PDI Photos' variable is in the attachments field of Send an Email V2, they are attached as one would expect. If i include the embed 'Outputs('Combine_Embed')', the photos are embedded, but the attachments no longer appear attached. If i remove the 'PDI Photos' variable from the attachments field of Send an Email V2, the embed and photos show up, but the data is missing/nonsensical and broken. Can anyone help?  Flow attached below.

[ekarim2020]

Hi @csbassplayer200 ,

To embed images in an Outlook email we need to get following details about the image:

• Content type: tells the browser what kind of file or content is being used so it can handle it correctly. (e.g. image/png)
• Content: the content of the image in base64 format

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[csbassplayer200]

As far as i see, i have this formatted correctly, what am i missing?

[ekarim2020]

Hi @csbassplayer200 ,

You need to to use the file content in the <img> tag.

Please see the following example as a reference: Solved: Re: How can I add an image to a V2 email. - Power Platform Community (microsoft.com)

The screen shots are taken from the above post:

 

 

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[csbassplayer200]

Does the content have to come from "get file content using path?". The target is a folder that contains a variable amount of files, a minimum of 4, so it needs to capture all files. Would that then need to be appended to an array or how would you proceed from there to capture all of the photos in the folder using that connector?

[ekarim2020 · Accepted solution]

Hi @csbassplayer200 ,

Here is a demo flow:

 

 

 

 

This is the HTML code for embedding images:

This is the expression in the code above:

outputs('Get_file_content')?['body']?['$content']

This is the Send an Email action:

 

 

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[csbassplayer200]

Worked like a charm! Looks like i did not have the append string step in there. Thank you for all of your assistance!