Unanswered

Embed Image from SharePoint Library in an Email

(0) Share

Report

Posted on by Digital

1,207

I have built an asset inspection app that lets my client take multiple photos per inspection which are stored in a SharePoint library. The inspection responses are stored in a separate SharePoint list They would like to be able to print a report with the images that they can also email to their repair contractor.

I initially set this up as an email with the photos as attachments, however they would like the images to be embedded in the email body. I understand this can't be done from Power Apps due to the images being stored in a SharePoint library. I experimented with the Print() function but they need to be able to print from the mobile app and the print function doesn't work from mobile devices.

In the past I have used Power Automate to convert HTML sent from Power Apps using OneDrive Convert File. The problem with this method is OneDrive Convert is limited to 2MB and my client would like to attach multiple images.

Is it possible for Flow to get the file content of the inspection images and add to HTML that can be used to send an email?

Wondering what is the best way to add this functionality. I feel this is functionality is desperately needed in Power Apps as attaching multiple images to a PDF report is a common business scenario.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Digital ,

Your first issue is that embedded images in an email are actually a hyperlink to the image stored on a URL This URL must be "anonymously" accessible (meaning no login required), so the image cannot be in SharePoint.

The issue with OneDrive (and also Google Drive) is that public sharing is possible, however the link is not able to be produced dynamically (you would need to do it to each photo), If this was always the same image, or you had a list of standard images with their links in a table, you could do this, but not for new ones.

I have resolved to using a Word Merge to PDF and attaching this to the email, but even this has limitations if you want multiple (an unknown number) of images as merge tables in Word can only contain Text.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz ,

I'm now thinking to get the base64 of the images from the document library using Power Automate then add this to as the img src.

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Digital ,

That actually got me thinking (I have never attempted this and I would have thought you still did not have an image URL "at the other end") - this article may be worth exploring.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Digital 1,207 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz , cheers for the link.

I've managed to get the base64 of the file and add it to the image tag and it successfully embeds in the email body.

Now I just need to get it to work for multiple files and make it look pretty. This is turning into a Power Automate thread!

Was this reply helpful? Yes No