Unanswered

Conditional color formatting html table column- Possible?

(0) Share

Report

Posted on by sgr

I have created html table through flow, is there a way to conditional color formatting depending upon the status as shown below and send through email?

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Hi @sgr ,

Please refer to this article to achieve your requirements:

https://alextofan.com/2019/02/14/flow-how-to-change-the-style-of-your-html-table-in-flow/

Best Regards,

Was this reply helpful? Yes No
Verified answer

sgr on at

Like (0)

Report

found more easier way through replace function. Thanks Laxmi Narayan.
here is for others who are looking similar;
replace(body('create_html_table'),'td>Risk','td style="color:red">Risk')

Was this reply helpful? Yes No
ainniss 8 on at

Like (0)

Report

I got the replace to work, but it removed the other formatting from my table.

I am not an expert with HTML. Can you advise where I should insert the replace(body........ expression.

See the format of my HTML table below.

<style>
table {
border: 1px solid #1C6EA4;
background-color: #ffffff;
width: 100%;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 10px 10px;
}
table tbody td {
font-size: 15px;
}
table thead {
background: #813f98;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 20px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>

Was this reply helpful? Yes No
sgrpdl 109 on at

Like (0)

Report

@ainniss Plz be little clear, what format is being removed?
Well you can create another find and replace condition just beneath the 1st one to mitigate the issues.

replace(outputs('FormatTable'),'<th>','<th style="padding:2px">')

Was this reply helpful? Yes No
ainniss 8 on at

Like (0)

Report

Hi

I guess my question should be, does the replace expression go within the Compose action for the HTML table format. or do I add another action which would be Compose 2 with replace(body'Create_html_table.....

In the first instance the replace(body worked for the text colour change but ignored all other table formatting.
In the 2nd instance the 2nd compose duplicated the HTML table.

Was this reply helpful? Yes No
sgrpdl 109 on at

Like (0)

Report

🙂 This way... @ainniss

Was this reply helpful? Yes No
ainniss 8 on at

Like (0)

Report

In my Data operations I do not have Format Table and Style table as options. I only have Compose.

I will attempt to use the 'Compose' for the replace to style the table but then do I replace all instance of they symbol { with < ???

Was this reply helpful? Yes No
sgrpdl 109 on at

Like (0)

Report

@ainniss Ya, you have do every thing in compose...
which can be renamed later as Format Table and Style...

Was this reply helpful? Yes No
sgrpdl 109 on at

Like (0)

Report

@ainniss
https://www.youtube.com/watch?v=FZGHmDlI-o4

I assume you are trying to do some thing similar like above? Have a look..

Was this reply helpful? Yes No
ainniss 8 on at

Like (0)

Report

Hi I actually used this video to help with the original table formatting. I need to add conditional formatting to that same table.
I have a R.A.G. column in the table where the values will either be R for red, A for amber(yellow) or G for green so based on the letter I need the colour to change.

Was this reply helpful? Yes No