cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

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
Post Prodigy
Post Prodigy

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
Post Prodigy
Post Prodigy

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

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (51,690)