Merging 2 or more HTML tables into one in flow

Like (0) Share

Report

Posted on 10 Mar 2023 01:38:51 by Sivaperumal31

Hello,

I have a flow where I I am looping every country to filter array from 2 share point list and creating 2 HTML tables out of it to send it an email. (Flow can be seen below ) .

But I want to merge the 2 HTML table output into one consolidated HTML before using it in Email step. I do not want to send 2 different tables inside a email . Both these HTML table output are having same columns , only difference is the Data.(Example can be seen below ) .

Ideally, I would like to avoid nested loop(Apply to each inside current Apply to each ) if possible.

Can you let me know of any way I can achieve this ?

Thank you

Current flow:

HTML table output example:

All responses (3)

Answers (1)

Amirin 128 on 14 Aug 2023 at 22:02:39

Like (0)

Report

Re: Merging 2 or more HTML tables into one in flow

Hi to the solution giver
I use your solution,, but my table does not have any grids. can you optimize your code? ^_^
Sivaperumal31 75 on 17 Mar 2023 at 04:14:54

Like (0)

Report

Re: Merging 2 or more HTML tables into one in flow

Thank you @v-dezhili-msft , It did the job for me. Appreciate it.
Verified answer

v-dezhili-msft Microsoft Employee on 10 Mar 2023 at 06:13:00

Like (2)

Report
Re: Merging 2 or more HTML tables into one in flow

Hi @Sivaperumal31 ,

If your two tables have the same format, you can hand-write an HTML table header, and then use the split() formula to cut out the table body and merge them together.

<table> <thead> <tr> <th>Name</th> <th>Grade</th> <th>Date</th> </tr> </thead> <tbody> @{split(split(body('Create_HTML_table'),'<tbody>')[1],'</tbody>')[0]} @{split(split(body('Create_HTML_table_2'),'<tbody>')[1],'</tbody>')[0]} </tbody> </table>

Best Regards,
Dezhi