Excel table with conditional formatting to mail body

[nailepmac]

Hi,

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?

Thanks

[Masa_]

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.
Regards,
--------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.