cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dmistry
Level 8

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
dmistry
Level 8

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

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

2 REPLIES 2
dmistry
Level 8

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

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

Jrasal
Level: Powered On

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

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

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,850)