Answered

send image via email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using a SendEmail function to report back the users of my App the data they create while completing inspections. The email is composed in html and references data stored in a temporary collection. I've been unable to include an image in that email so far.

I've tried to save the data URI of the image in the collection and then call on that data in the email, but it appears that Outlook doesn't support embedded images in their emails: https://www.campaignmonitor.com/blog/email-marketing/2013/02/embedded-images-in-html-email/

Is there a way to send my users the images they collect in the app via an email?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
Try the following way:

1. Add Office 365 Outlook connection,

2. Add HtmlInput control, under the HtmlText property, input with the line below:

"Show your <b><font color=blue>HTML</font></b> text here.
<img src=""https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTf8peeAQ8Jbw4lowjdYM9OYVJFJr8EwgGNTsJ6BtbqPdNHWz2m"" alt=""Testing"" width=""500"" height=""100"">"

Things to mind is, when using the img tag within the HTMLText control, we need to add double quotes twice where it needs a double quote.

3. Add a button, then sepcify the following code example, make sure the IsHtml has been configured to true:

Office365.SendEmail("123@test.com","Testing",HtmlText1.HtmlText,{IsHtml:true})

The results:

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you for the reply!

I've been trying variations on your solution, but so far none have worked. My images are stored in dropbox adjacent to an excel sheet which serves as my database. I don't know how to refer to them using "https..." as they are not on a webpage? Although I did see s similar notation when I erroneously referred to the image's relative file location. I also collect the images in a temporary collection for use in generating the html email.

I add the image to the collection by referring to the image control
Collect (records, {TestPic: imagecontrol.Image})

I create table headers above and then refer to the image in the html email with the following:
Concat(record, "<tr> <td><img src="&TestPic&" alt="" height=100 width=100></img></td>
... </tr>
This code produces a 100x100 cell in the final table with a broken image symbol in it.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe this will help? Not exactly what you are trying to do but this is a video on me emailing a Pen Input image. Maybe seeing the mechanics will help.

PowerApps email a pen input image

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the help.

Sending the images as attachments looks promising. I have the images saved in a collection "record" in a column "Pic" and so far PowerApps doesn't like it:

Office365.SendEmail(User().Email,"Inspection Report "&Today(),reporthtml.HtmlText,{Attachments:Table({Name:"image.jpeg",ContentBytes:record.Pic , '@odata.type':"",IsHtml:true})})
I get the following errors:
The type Table is invalid for column 'ContentBytes'; Blob expected.
Invalid argument types. Expecting a Table value, but of a different schema.
The function 'SendEmail' has some invalid arguments.
See anything wrong with my code?

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What is your code for putting the image in the collection? I see why your doesn't work but I don't know the exact syntax to tell you to fix it without creating my own app.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the video link btw. Those are great!

Since I'm experimenting around to get this to work, I'm saving the image to the collection in two different ways using the OnSuccess property of my InspectionForm.

Collect(record,InspectionForm.LastSubmit,Image4_2.Image); ResetForm(InspectionForm); Navigate(PISelect,Fade)
The image is saved to my database via the Update property of a datacard. This saves the image to a folder adjacent to my Excel sheet database and puts relative file location in the Excel cell where the image would go.

The image should be added to my collection as part of the record collected as InspectionForm.LastSubmit (I think this adds the relative file location to the collection?) and the image is collected as Image4_2.Image

Here is an image of my collection. It appears that Image4_2.Image is added to the collection in a column named Url, since Pic is the name of the image column in my database:

Was this reply helpful? Yes No
QuentinFerreira 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Jdscott,

I have the same problem. I followed Shane's video about e-mailing pictures thanks to collection.
I got the same 3 problems.

Did you find the solution already ?

Thanks for your attention

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(5)

Report
Copy link

Link copied!
Hey QuentinFerreira!

It took a long break and some deep reflection on the direction my life was taking, but I did figure it out eventually. Here are the basic steps:

Whether you are saving your images to a database or not, you need to save the images you want to email to a collection. I use the "submit button" on my form to submit the form and to collect the images. One image is being both submitted and collected to my ImageCollection.
When you collect the images, you need to collect at least the following:
Collect( ImageCollection, {Name: YourName.jpg", ContentBytes: YourImageControl.Image, '@odata.type':""})
The code I use to send the email is functionally similar to the following. I use some filters in there to make things easier, but that's not too hard to do.
Office365.SendEmail( User().Email, <! the email is sent to whomever is loggin into the app> "Report Name", <! name of the email, the subject> emailtext.HtmlText, <! the content of the email, the body, I wrote it in html> {Attachments: ImageCollection, IsHtml:true}) <! attach your ImageCollection>
This should collect images and send them all in an email. I'm assuming you have an html email already written that you want to send as well.

I hope this helps!

Was this reply helpful? Yes No
marcusramos 29 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, I have created the collection and I can see the images inside the collection perfectly.

ClearCollect(CollectImagesEmail,{Name: Title6_1.Text&".png", ContentBytes: Image4_1.Image, '@odata.type':""})

I am using this script to send e-mail.

Office365.SendEmail((User().Email)&ccemailbox.Text&"","Order - " & Gallery1.Selected.'Site Name',HtmlText3.HtmlText,{IsHtml:true,
Attachments: CollectImagesEmail})

But when I try to send the e-mail I am getting this error message:

Office.365.SendEmail Failed: One or more erros occurred. Reporting the first one: The server returned an HTTP error with code 0.

Could you advise?

Kind regards

Marcus Ramos

Was this reply helpful? Yes No
hpkeong_Malaysi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Thanks for good guide.
I follow the idea and get the email but with Attachemwnt and name but the Attachemwnt is with empty Images but broken code inside.

If I email the image directly it is OK just if I use collect the above happened.

Any clue?
Tq

Was this reply helpful? Yes No