footer for power automate html table

[jainu]

Hi Team,

I want to send a daily report from SharePoint list to crewmembers using power automate. I done that one  . I used 'Create HTML Table'  to create the table. I want to add some more data like 'Total Quantity', 'Total Area' etc. to the table as footer . Someone please suggest how can I add footer with some data into that HTML Table.

[Mira_Ghaly]

@jainu 

You can use compose data operation to append to your output of the HTML table something like below:

[jainu]

Hi Mira,

I tried that way. But I need something like this.

[Mira_Ghaly · Accepted solution]

@jainu 

Please try the below steps to insert Table Footer:

1. Add a compose data operation with a Split function to get the string before the closure of table </table> 

split(body('Create_HTML_table'),'</table>')

2. To get the Pre Table closure tag </table> Use below Expression

outputs('SplitByTableClosure')[0]

3. Compose your table footer using another compose operation where you add the required <td> Columns an there values as required:

4. Concatenate tBody output with tfooter output as below

concat(outputs('tbody'),outputs('tfoot'))

[jainu]

Hi Mira, 

the email report is coming like this.

[Mira_Ghaly]

@jainu 

Please make sure that you are using the Expression Pane when using any of the expressions as below:

Hope this helps!

[jainu]

@Mira_Ghaly 

Hi Mira,

 footer is showing an error when I write HTML Code in expression as shown below

[Mira_Ghaly]

@jainu 

For the tFooter you do not need an expression but still for sure you might need to use the Expression pane if you want to concatenate your totals.

[jainu]

@Mira_Ghaly 

Yes. It is working. Thank you so much