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.

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 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 (3,013)