cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to format the table as Rich text in send an email body action listing all tasks assigned to user

Hi,

 

I have a flow setup that sends an email to notify users about tasks assigned to them with start date, end date and task status info. I am leveraging create html table action and using output of it in send email action. I used solution provided here to build an exact replica: https://powerusers.microsoft.com/t5/General-Flow-Discussion/microsoft-flow-get-all-items-with-distin...

 

Based on solution provided here: https://powerusers.microsoft.com/t5/General-Flow-Discussion/Create-HTML-and-formatting-the-table-as-..., I was able to make font changes but I want to make more formatting changes.

 

Below is the send an email action from flow.

flowemail.PNG

   

The email I receive is shown as below:

EmailNotification.PNG                                                                

what formatting HTML should I add to make it look similar to below: Basically adding borders for table, tr and th tags so readability can be improved.

Capture.PNG                                       Can someone please help me with a solution, thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

After spending some time in research I was able to convert the output into a tabular format with the help Kamil's comment here: https://powerusers.microsoft.com/t5/Flow-Ideas/Formatting-Create-HTML-Table-Action-with-HTML/idc-p/2...

 

As mentioned by Kamil on above link, right below create html table, I simply added a compose action with following formula: replace(body('Create_HTML_table'),'<table>','<table border="1">') it does the job. See below screenshot for flow and email notification.

 

Capture.PNG

 

Capture.PNG

 

Hopefull this helps someone.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

After spending some time in research I was able to convert the output into a tabular format with the help Kamil's comment here: https://powerusers.microsoft.com/t5/Flow-Ideas/Formatting-Create-HTML-Table-Action-with-HTML/idc-p/2...

 

As mentioned by Kamil on above link, right below create html table, I simply added a compose action with following formula: replace(body('Create_HTML_table'),'<table>','<table border="1">') it does the job. See below screenshot for flow and email notification.

 

Capture.PNG

 

Capture.PNG

 

Hopefull this helps someone.

Jrasal
Frequent Visitor

Thank you, this was a great fix for my problem as well.

This is a great suggestion, but I cant get it to work when producing a PDF file.
I added the suggested step right after "Create HTML table" and before "Create file"

Any suggestions on getting the same result when convering to PDF?
flowww.JPG

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,891)