Answered

Embed image into automated email from Sharepoint list

(0) Share

Report

Posted on by Jtaylor95

126

I have a flow set up whereby an email is sent when a new item is added to a sharepoint list and pulls through dynamic content from the list itself (see below)

Screenshot 2022-05-20 at 1.23.24 pm.png

I have another column on my list for images (see below called 'ID Picture') and I need this image embedding into the email body or even an attachment. Any help welcome!

Screenshot 2022-05-20 at 1.23.42 pm.png

Thanks!

I have the same question (0)

All responses (21)

Answers (1)

CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

Hey @Jtaylor95

Is the Picture an Hyperlink?

If yes, please try to use <img> label in HTML, then the image could be checked on Outlook Web.

<img src="@{triggerOutputs()?['body/Picture']}" alt="Picture" width="500" height="600">

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

No the picture isn't a hyperlink its a jpeg thats been uploaded

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

@Jtaylor95

So is it an attachment? Then try the below -

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

No its not an attachment either. I want the image to be pulled from Sharepoint List and embedded as an image into the email body

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

What is the column type in SharePoint? Can you please provide more details?

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

column type is an image. So its just uploading a .jpeg or .png

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

@Jtaylor95 - Screenshot of the column please.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report

Re: Email when a new item is created in a SharePoint list to include image from the list

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (1)

Report
Re: Embed image into automated email from Sharepoint list

Hi @Jtaylor95 ,

I have made a test for your reference.
1. Here is my SharePoint list.
2. Here is my flow.
_api/web/Lists/getByTitle('listname')/items(@{triggerOutputs()?['body/ID']})?$select=ImageColumnName
json(body('Send_an_HTTP_request_to_SharePoint')?['d']['ImageColumnName'])['fileName']
concat('/SiteAssets/Lists/yourfoldername/',variables('image1filename'))
<img style="display:block;" src="data&colon;image/jpg;base64,@{body('Get_file_content_using_path')['$content']}" alt="ImageColumn1" border="0" width="300" height="300">
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Re: Embed image into automated email from Sharepoint list

Can you clarify how to enter the 'listname' in the below?
_api/web/Lists/getByTitle('listname')/items(@{triggerOutputs()?['body/ID']})?$select=ImageColumnName

I've tried 'Salaried_Employee_Test' and also 'salariedemployeetest' but its not recognising the list?

Was this reply helpful? Yes No