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
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.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,345)