Answered

Embedding images into email from SharePoint list

(1) Share

Report

Posted on by FueldByCoffee

Howdy folks,

I have an existing flow that gets attachment data from new SharePoint list entries and appends them to an array to be sent out as email attachments. I have been asked if I can embed the images into the body of the email and that has me stumped.

I understand how to add an image to the body using the concat function, but what do I do when the amount of potential images is undefined? There could be one image or 10...

Thank you.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Anil_g 668 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@FueldByCoffee

I beleive you can loop in the files and repeat the concat function inside the loop to make all the files as attachment and add all of them together

cheers
Verified answer

FueldByCoffee 11 on at

Like
a
(1)

Report
Copy link

Link copied!

For anyone looking for an answer to this in the future:

I was overthinking this. Create a string variable, for this we'll call it varEmbedImages. Then do a apply to each loop on the SharePoint list attachments > "Get attachment content" > Compose "dataUri(body('Get_attachment_content')" > Append to string variable Name: varEmbedImages Value: "concat('<br>','<img src="',outputs('Compose_-_Image_URI'),'"alt = />')"

I hope this helps someone else down the line.
CU24070609-0 on at

Like
a
(1)

Report
Copy link

Link copied!

@FueldByCoffee

Can you please share full the flows with me?

Thanks.

David