Hello.
I have a flow, triggered with PowerApps button.
In details there is a dynamic content which I am getting from PowerApps and I get it with function Concat
As a result I recieve an email with body:
How can I change it to table like this?
Solved! Go to Solution.
@ppl ,
@rubin_boer has a good point - this should insert it in the body of the email
"<table>
<tr>
<td><b>Article</b></td>
<td><b>Title</b></td>
<td><b>Price per one</b></td>
<td><b>Qty</b></td>
<td><b>Total price</b></td>
</tr>" &
Concat(
YourCollection,
"<tr>
<td>"&Article&"</td>
<td>"&Title&"</td>
<td>"&'Price per one'&"</td>
<td>"&Qty&"</td>
<td>"&'Total price'&"</td>
</tr>"
) &
"</Table>"
hi @ppl
have a look at this https://powerusers.microsoft.com/t5/Building-Power-Apps/send-Gallery-List-via-email-through-powerapp... or you can add a table in flow, Ryan Maclean has a great blog on it, here: https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
Hope it helps
Ps simply curious, any reason why you opt not do the logic in power apps?
@ppl ,
@rubin_boer has a good point - this should insert it in the body of the email
"<table>
<tr>
<td><b>Article</b></td>
<td><b>Title</b></td>
<td><b>Price per one</b></td>
<td><b>Qty</b></td>
<td><b>Total price</b></td>
</tr>" &
Concat(
YourCollection,
"<tr>
<td>"&Article&"</td>
<td>"&Title&"</td>
<td>"&'Price per one'&"</td>
<td>"&Qty&"</td>
<td>"&'Total price'&"</td>
</tr>"
) &
"</Table>"
Thank you!
Its ok in simple email in my flow,
but in Approval email I am seeing html code.
hi @ppl can you please post your flow. i assume you do have a Create HTML table in it?
User | Count |
---|---|
149 | |
94 | |
85 | |
78 | |
58 |
User | Count |
---|---|
193 | |
175 | |
104 | |
95 | |
91 |