Create HTML and formatting the table in an email

[leyburn19]

I use 'Create HTML' successfully based on data from a SPand pass the result into an email.  What I would like to do is modify the table result to show borders etc.  Is there a way to do this.  There are no advanced settings I can see for this

[leyburn19 · Accepted solution]

OK solved this by adding a second compose "data operations Compose" and used teh following syntax

replace(body('Create_HTML_table'),'<table>','<table border="1">')

Where 'Create_HTML_table' = the name of the Create HTML compse

Basically the replace would allow you to modify anything in the table

[karthiksankar]

Please let us know the inputs need to be populated on Create Html From field ..it should be body  or something else. when i tried body it updated sharepoint link not email

[leyburn19]

The inputs in most cases for me is the result from a 'select' action step.  The select puts a rows from a list into an array table with column headers etc which you can then use the result to be put into a create html table.  

This does not show borders,  hence the need for the replace function