Sharepoint Comments into HTML Table into Excel

[mmarchetti]

Hello!

I am fairly new to using  Power Automate - Looking for some help.

I am trying to export the Comments from a SharePoint list into a clean Excel Table. I am successfully able to export a list item's comments into an Email (by creating a HTML table), but when I try to consolidate them into an Excel file, it fails.

Any ideas? I am not set on using the HTML table if someone has other ways to retrieve and track the comments added on SharePoint lists.

Thanks!

Marissa