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.
Solved! Go to Solution.
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'))
Hi Mira,
I tried that way. But I need something like this.
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'))
Hi Mira,
the email report is coming like this.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
24 | |
20 | |
9 | |
8 | |
7 |
User | Count |
---|---|
39 | |
30 | |
26 | |
23 | |
13 |