Answered

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)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

🙂 This way... @ainniss

Was this reply helpful? Yes No
ainniss 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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