How to email a collection as attachments?

[jzhang]

Hi, I am trying to email some collections as an output of powerapps. In the attachment option, what do I need to specify in the ContentBytes and odata.type fields, if my collection is already a table?  I have seen ways to convert collections of photos and other files into table, but not sure what type I need to specify if it is already a table. 

I have got the error message: 

[v-yutliu-msft · Accepted solution]

Hi @jzhang ,

Do you want to send an emial that contains a table?

1)send a table by using html text

Try this formula:

Office365.SendEmail(
     "email address",
     "subject",
     "<h3>tablename</h3>" &
     "<strong> Items: </strong>" &
     "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef'>
      <th>fieldname1</th> <th> fieldname2 </th> <th> fieldname3 </th><th> fieldname4 </th>
     </tr>
     <tr>" &
    Concat('The data source/formula that you provided within the Items property of your Data Table control',
       "<td>" & fieldname1 & " </td>
        <td>" & fieldname2 & " </td>
        <td>" & fieldname3 & " </td>","</tr><tr>") &
    "</table>",
    {
     IsHtml:true
    }
)

Please replace the red part with your data.

Here's my test for your reference:

Here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/Expressions-and-Formulas/Data-Table-to-Email-in-PowerApps/td-p/1...

2)convert a table to an image, send an email with attachment

Try this formula:

Office365.SendEmail(inputTo.Text, inputSubject.Text, inputBody.Text, {Attachments:Table({Name:"file1.jpg", ContentBytes:filevalue, '@odata.type':""})})

Here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/General-Discussion/Email-with-attachment/m-p/239607

Best regards,

Community Support Team _ Phoebe Liu