Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Excel table with conditional formatting to mail body


So I am sending my colleagues an excel table via flow, by email. I list rows and then send an html table. The problem is that they want a conditional formatting to read better the table.


How can I achieve this without too much programming?  Is there a way to automatically save an excel table as picture (this would keep the colors) and then embed it?


Could you please give me some ideas?



Helper I
Helper I

I've tested it with standard Power Automate features to see if it meets this need.
It doesn't meet all of your needs, but some can.

  1. Format the table for the Excel cell
  2. Get Excel data with [List the rows that exist in the table] action
  3. Select only the required columns in [Choice]
  4. Convert the output of Choice to a table with Creating an HTML table
  5. Add the output of [Creating an HTML table] to the body with [Send email (V2)]
  • you can achieve: You can get the Excel formula
  • Unachievable: Character formatting (font, bold, display format), borders, cell colors


If you have a way to save an Excel table as a diagram, that's a surefire way.
In addition, Power Automate Desktop Flow will streamline the operation of saving as an image.


Below is a sample test.






 I used google translate.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,638)