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:
Hi @Anonymous ,
Do you want to send an emial that contains a table?
1)send a table by using html text
Try this formula:
Share
Report
All responses (
Answers (
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
382
