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?
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?
Now your query is clear, What i did in my case is
a) I have used inline CSS, not style css
b) First Create a CSV Table. I gave name "Create_HTML_table"
c) Now, Format the table with find and replace based on the R.A.G. The Col name is 'Status' in my case.
d) you can add padding in next compose as shown in Style in my case.
Format TABLE QUREY
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.
@ainniss
https://www.youtube.com/watch?v=FZGHmDlI-o4
I assume you are trying to do some thing similar like above? Have a look..
@ainniss Ya, you have do every thing in compose...
which can be renamed later as Format Table and Style...
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 < ???
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.
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>
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')
WarrenBelz
146,702
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,026
Most Valuable Professional