Unanswered

HTML table output

(0) Share

Report

Posted on by JustAsking

Hi.
I'm a new power auto user and I've been fumbling with this problem for a few days now. I can't seem to get the html table output to display as a table. The ouptut shows as code. Can anyone point me in the right direction here please.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (2)

Report
Hi @JustAsking,

Is your Create HTML table action outputting characters like < as < ? If so you can clean up the HTML outputs of that Create HTML table action with a couple of replace functions.

Below is an example

Use the expression below after the Create HTML table action

replace(replace(replace(replace(replace(body('Create_HTML_Table'), '<', '<'), '>', '>'), '&amp', '&'), ''', '"'), '"', '"')

Was this reply helpful? Yes No
JustAsking 10 on at

Like (0)

Report

Hi, the output from the Create HTML table looks like this:
<table><thead><tr><th>Silo</th><th>Invoices</th></tr></thead><tbody><tr><td>BCS</td><td></td></tr><tr><td>GDS</td><td></td></tr><tr><td>KVI</td><td></td></tr><tr><td>NON-GDS</td><td></td></tr><tr><td>OLA</td><td></td></tr><tr><td>SAF</td><td></td></tr><tr><td>SNL</td><td></td></tr><tr><td>SSA</td><td></td></tr><tr><td>UDP</td><td></td></tr></tbody></table>

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @JustAsking,

Yes, that is expected outputs. That is table HTML.

How are you sharing/do you want to share this HTML table, in a Send an Email (v2) action?

Was this reply helpful? Yes No
JustAsking 10 on at

Like (0)

Report

Thank you @Expiscornovus . I've watched some videos where the HTML table output displays in a column style so I figured I had something wrong. I do want Send an Email (v2).

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @JustAsking,

In that case use the outputs of that action in the Body field of that Send an Email (v2).

You can also switch that Body field to code view (with the </> button) to add your own html markup as well. Below is an example

Was this reply helpful? Yes No
JustAsking 10 on at

Like (0)

Report

You've been a great help. Thank you very much.

Was this reply helpful? Yes No