Unanswered

Get HTML file contents and add to a SharePoint List

(0) Share

Report

Posted on by PiminMaito

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
PiminMaito 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

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.

Regards,
Henrique

Was this reply helpful? Yes No