Good Afternoon
I'm compiling a table from SharePoint list items and placing it into an email. Trouble is that any text that comes after for some reason ends up in the table and nothing seems to work.
This is the code in the email:
<strong>@{outputs('Get_item_PO')?['body/Title']}</strong><br>
Vendor: @{outputs('Get_item_PO')?['body/Vendor/Value']}<br>
Project: @{outputs('Get_item_PO')?['body/Title']}<br>
Amount: @{formatNumber(float(outputs('Get_item_PO')?['body/POAmountTotal']),'c','en-NZ')}</p>
<p></p>
<p>@{outputs('FormattedTable')}</p>
<p></p>
<span style="color:#3232b4">Please Reply All to keep the approval thread.</span style="color:#3232b4">
<p>Thanks,<br>
And this is what it looks like in the email:
And if you're wondering why I'm not using approvals ... one of my approvers doesn't like it. And since it's actually quite hard to get the Approvals result into an external system, an email will do just as well.
Thanks, Christine
Solved! Go to Solution.
Hello @Amapola188 ,
my guess would be that you don't close the <table> tag when building the HTML table. Try to add the </table> after the dynamic content with the table.
<strong>@{outputs('Get_item_PO')?['body/Title']}</strong><br>
Vendor: @{outputs('Get_item_PO')?['body/Vendor/Value']}<br>
Project: @{outputs('Get_item_PO')?['body/Title']}<br>
Amount: @{formatNumber(float(outputs('Get_item_PO')?['body/POAmountTotal']),'c','en-NZ')}</p>
<p></p>
<p>@{outputs('FormattedTable')}</table></p>
<p></p>
<span style="color:#3232b4">Please Reply All to keep the approval thread.</span style="color:#3232b4">
<p>Thanks,<br>
Hello @Amapola188 ,
my guess would be that you don't close the <table> tag when building the HTML table. Try to add the </table> after the dynamic content with the table.
<strong>@{outputs('Get_item_PO')?['body/Title']}</strong><br>
Vendor: @{outputs('Get_item_PO')?['body/Vendor/Value']}<br>
Project: @{outputs('Get_item_PO')?['body/Title']}<br>
Amount: @{formatNumber(float(outputs('Get_item_PO')?['body/POAmountTotal']),'c','en-NZ')}</p>
<p></p>
<p>@{outputs('FormattedTable')}</table></p>
<p></p>
<span style="color:#3232b4">Please Reply All to keep the approval thread.</span style="color:#3232b4">
<p>Thanks,<br>
Hi Tom - Spot on. My HTML is very basic! Thanks so much.
BTW, I really love your work. So practical and useful!
Working nicely now. - I've also added a   into the paragraph after the table. It doesn't seem to pick it up otherwise and sticks the sentence too close to the table.
User | Count |
---|---|
89 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
26 |