Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get HTML file contents and add to a SharePoint List

Hi Everyone, hope someone can help me out here


I get a daily e-mail with HTML content and in it is an HTML table. I have build a flow that extracts the HTML table and saves it as .html file on a SharePoint location. These daily files are in turn used as a Data Source for my Power Bi report -> Power Query has no problem reading this and all comes out fine, so far so good.


I would also like to extract the daily table and add the table items <tr> to a SharePoint list, however, I cannot seem to convert the HTML file in Power Automate (although just opening the file in Excel works fine). 


Does anyone know a clever way to convert the HTML table (which seems to be a String when using "file content") into something useful that can be read and put in as items on a SharePoint List? Seems to me that since Power Query is compatible with HTML, there should be a solution here ? 🙂 Any advise is appreciated!


Thanks in advance! 

Super User
Super User

hi @PiminMaito  as an action to organice information inside not my friend unfortunally does not exist yet.

Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!

If you want you can follow me at Quieres contenido en español? Síguenos en Power Automate LA

Hi @ChristianAbata thanks for taking the time to review and getting back to me.


I may have found some sort of solution in combination with PowerBI/PowerApps: here is a blog post.


Basically in my use-case it comes down to this:


Use Flow to extract HTML table from an e-mail and save as HTML

Use PowerBI to set-up a PowerQuery to combine all the HTML into a data table

Then, apply the posted solution of combining PowerBI with PowerApps, from the blog post to generate CSV output, which in turn can be used again in a Flow to put items on SharePoint... 


I'll see how I get on with that.



Not applicable



Any solution for this topic?


I have the same issue here and unfortunately I am not able to add the HTML attachment content to a Sharepoint List.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,798)