Select is not passing HTML

(1) Share

Report

Posted on by Pjames43

I want to put some conditional formatting inside a table in my Power Automate. Right now, I am just testing passing formatting inside the Map based on some other posts I read.

However, instead of passing the HTML it is converting them to the markups codes.

When I look at the output code of that select function it looks fine:

"All Pass": "<div style='background-color: green'>Yes</div>",
 
But then I put it into an HTML table:
And instead it is putting this in table:
<td>&lt;div style=&#39;background-color: green&#39;&gt;Yes&lt;/div&gt;</td>
 
Is there a way to get the HTML to stick? Do I need to escape it somehow?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

You should really add the Html formatting to another Compose, so it will work properly.

Here are 2 great resources... which reminds me to fix my darn blogs :-)

Foolproof Power Automate HTML Table Styling (matthewdevaney.com)

Power Automate Create Html Table | Style & Formatting - Letstacle

If you apply the Styling this way, it will work.

Was this reply helpful? Yes No
Pjames43 77 on at

Like (1)

Report
Copy link

Link copied!

I already have the bulk of the HTML formatting in another compose function. My ultimate goal is to make the formatting of soem cells conditional. For example, certain fields on the form are YES/NO questions. I want to change the background of that cell in the table based on contents of that cell. I was thinking I could put the if() statement inside the field on the "Map" something like this...

The if() is working just fine, but the text has the same issue on the back end. I don't see how I can put the if() in the Compose function and have conditional formatting for individual cells. I had originally, tried it without the Select function and just directly creating the HTML Table and that had the exact same issue.

Was this reply helpful? Yes No
Suggested answer

Robby_WW 115 on at

Like (1)

Report
Copy link

Link copied!
add a compose and use this as formula.

replace( replace( replace( replace( replace(body('Create_HTML_table'), '<','<'),'>','>'),'&','&'),''','"'),'"','"')

Was this reply helpful? Yes No
Suggested answer

Mark277 9 on at

Like (1)

Report
Copy link

Link copied!

Hi! It's actually quite easy to solve your problem.

In your Action "Create HTML Table" show the Advanced parameters and choose Custom Columns, there you'll have to set the Headers and corresponding values like in your Select Action. BUT! Encapsulate each value in an "encodeUriComponent()" function.

After this you'll add a "Compose" Action with the function decodeUriComponent(body('Create_HTML_Table')) and all the values should have what you need.

Was this reply helpful? Yes No