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!
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.