cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jdscott
Level: Powered On

send image via email

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?


Accepted Solutions
Jdscott
Level: Powered On

Re: send image via email

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!


All Replies
Community Support Team Rank
Community Support Team

Re: send image via email

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:

8.PNG

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jdscott
Level: Powered On

Re: send image via email

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.

Super User Rank
Super User

Re: send image via email

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

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Jdscott
Level: Powered On

Re: send image via email

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?

 

 

 

Super User Rank
Super User

Re: send image via email

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.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Jdscott
Level: Powered On

Re: send image via email

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:

Capture.PNG

QuentinFerreira
Level: Power Up

Re: send image via email

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
Level: Powered On

Re: send image via email

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!