cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nailepmac
Frequent Visitor

Excel table with conditional formatting to mail body

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

1 REPLY 1
Masa_
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.

2021-02-27_10h43_18.png

 

2021-02-27_10h19_41.png

 

2021-02-27_10h20_23.png

 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.

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.

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)