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,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
PiminMaito 12 on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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