send image via email

[Jdscott]

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?

[v-micsh-msft]

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

[Jdscott]

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.

[Shanescows]

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

[Jdscott]

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:

1. The type Table is invalid for column 'ContentBytes'; Blob expected.
2. Invalid argument types. Expecting a Table value, but of a different schema.
3. The function 'SendEmail' has some invalid arguments.

See anything wrong with my code?

[Shanescows]

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.

[Jdscott]

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:

[QuentinFerreira]

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

[Jdscott · Accepted solution]

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:

1. 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.
2. When you collect the images, you need to collect at least the following:
   

   Collect( ImageCollection,
     {Name: YourName.jpg", ContentBytes: YourImageControl.Image, '@odata.type':""})

3. 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!

[marcusramos]

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