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:
Solved! Go to 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:
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
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:
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
User | Count |
---|---|
253 | |
109 | |
92 | |
48 | |
37 |