Hi, lukasz2.
I'm pretty new to Power Automate and I am keen to understand in a bit more detail what you did.
Would you mind adding a few screen shots of the last part of your flow so I can see the steps?
I am trying to add a paginated Power BI report (.mhtml) to the body of an email - I can get to attaching the .html file to the email, having followed your steps (see attachment) but not sure how to:
- use the Replace() function to remove the unwanted after creating the .eml file
- bring the html into the body of the email
Cheers.
Niall.
Hi, lukasz2.
I managed to get the .html into the email body, but still not too sure how to do it dynamically and also still unsure about the replace().
If you wouldn't mind letting me know.
Cheers.
Niall.
@nialls
If you have already converted eml > html everything you have to do is directly in the body mail.
when creating an eml file, it automatically creates a message header which looks like this, from what I can see it always looks the same:
to get rid of it you have to see the source of the file, in our case it will be:
<table style="font-family:Times New Roman; font-size:12pt">
<tbody>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">From:</td>
<td></td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">Sent on:</td>
<td>Monday, January 1, 0001 12:00:00 AM<br>
</td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">To:</td>
<td></td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">Subject:</td>
<td><br>
</td>
</tr>
<tr style="height:18px; vertical-align:top">
<td> </td>
<td> </td>
</tr>
</tbody>
</table>
now you just have to use the replace function to remove it directly in email body (not an attachment)
replace(outputs('Convert_file_using_path')?['body'],'<table style="font-family:Times New Roman; font-size:12pt">
<tbody>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">From:</td>
<td></td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">Sent on:</td>
<td>Monday, January 1, 0001 12:00:00 AM<br>
</td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">To:</td>
<td></td>
</tr>
<tr style="height:18px; vertical-align:top">
<td style="font-weight:bold; white-space:nowrap">Subject:</td>
<td><br>
</td>
</tr>
<tr style="height:18px; vertical-align:top">
<td> </td>
<td> </td>
</tr>
</tbody>
</table>','')
my power automate is in Polish so i didn't want to send screenshots, but if it helps you, screenshot below:
I am trying to embed a Power BI report into the email body as HTML. the only option I can see to export the report are PDF, PPTX, and PNG any idea how I can embed these types in the email body.
If I used the Paginated report I could see more file extensions such as MHTML, and XML.
also, I read the above solution and I was wondering how you convert from MHTML to EML
Hi there.
Instead of using 'Export to File...' I would choose 'Run a query against a dataset'.
Once you have created the table in your report which you want in your email body (and published it to the Power BI service), get the underlying DAX. See below:
Choose your workspace and dataset and paste in your DAX:
Then use 'Create HTML table', adding 'First table rows' for your dynamic content:
Then using 'Compose' add your CSS styling:
This is what I added (loads of options on sites like this: https://divtable.com/table-styler/
<style>
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 100px;
text-align: center;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 5px 5px;
}
table tbody td {
font-size: 13px;
}
table tr:nth-child(even) {
background: #D0E4F5;
}
table thead {
background: #1C6EA4;
background: -moz-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
background: -webkit-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
background: linear-gradient(to bottom, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
table tfoot td {
font-size: 14px;
}
table tfoot .links {
text-align: right;
}
table tfoot .links a{
display: inline-block;
background: #1C6EA4;
color: #FFFFFF;
padding: 2px 8px;
border-radius: 5px;
}
</style>
Then create your email - include the output from your Compose with your CSS styling first and then your output from 'Create HTML table':
My table in my report in Power BI looks like this:
This is the email output:
Formatting may need work so you can arrange the columns and format accordingly via choosing 'Custom' in the advanced options of 'Create HTML table' piece. For example if we wanted to change the column header and date format of the 'equityTrades[settleDate]' column in my example we would do the following:
You need to add all the columns you want in your final output, as well as the ones you are formatting and renaming.
Hope this helps.
Cheers.
Niall.
Hi there.
I'm really not sure, mloyalka.
Graphs will always be tricky in HTML compared with tables and text.
I don't work with graphs so I haven't encountered a similar problem to you, which I had to solve.
Can you use the standard subscriptions through the PowerBI Service and include the preview, as per below:
Only thing I can think of to display these graphical visuals in the body of the mail. But then you can't add your HTML table so would be a sacrifice somewhere.
Sorry I can't be of more help - all the best with it.
Thanks.
Niall.
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
