cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhilGlew
Helper III
Helper III

Conditional formatting colours in HTML table when emailled

I have a flow which Get Items from Sharepoint > Select (the columns and values from the SP list) > Create HTML table > Send via shared mailbox.

 

The output of this is perfect.

 

However, I would like conditional formatting to be added, as follows:

 

On the column of Priority, there are only six possible values. These are Critical, High, Medium, Low, Backlog and blank. I want colors to appear in the email for these cells in the table - so, when it's Critical = that cell goes dark red, High = red, Medium = amber, Low = Green and Backlog = Grey.  If it's blank, I don't want any colour on that cell.   The text should be in White. 

 

How can I do this?   I am not particularly bothered about the shades of these colours, but can provide HEX values if needed.

 

Thanks, 

 

Phil

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User
Dual Super User

Hi @PhilGlew ,

 

Check https://www.youtube.com/watch?v=VnWg-Eox37Q

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

 

View solution in original post

2 REPLIES 2
StalinPonnusamy
Super User
Super User

Hi @PhilGlew 

 

Please refer to the below article for conditional formatting. I haven't tried this but promising

 

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

 

 

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

RezaDorrani
Dual Super User
Dual Super User

Hi @PhilGlew ,

 

Check https://www.youtube.com/watch?v=VnWg-Eox37Q

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,723)