cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jdscott
Helper II
Helper II

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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!

View solution in original post

9 REPLIES 9
v-micsh-msft
Community Support
Community Support

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.

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.

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

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?

 

 

 

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

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

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

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!

View solution in original post

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

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,256)