How to convert a HTML Table to JSON with Power Automate

Example of how to convert a HTML Table to JSON in Power Automate, answer to Power Automate community question:

If you found this solution useful, I'd appreciate a donation to the channel:

[hostile_technics]

Thank you very much for this. I was looking for this solution for 2 weeks.

[luisvallejosloconi]

Thank you so much. You are the best. Greetings from Perú 🇵🇪

[anniekostadinova]

Thank you for sharing the video. Please do create more videos like this. I would love to see more examples of how to use Power Automate.

[davidnjoroge]

Quite useful. Thank you so much. Question: What if you want to extract data whenever a new email arrives and the table data varies in the number of rows? i.e one email might have one row of data and another might have 2 or even more rows?

[Plonoord]

This video helped me a lot, thank you Paulie

[usiala]

Thank you for Sharing, great content.

[kenhardin]

Great Video! I'm lost though on how to go from the final action "Select" to Insert Row into excel. Any thoughts?

[dushy]

Thank you so much dude. It resolved my issue

[babypooful]

I tried the HTML to text action but it couldn't pickup the column names in the email

[ahtiblumkvist-dujf]

Hello,


Instead, i used Filter array expression @equals(empty(trim(item())), false), which works beautifully. Not sure why the lenght variation doesn't work.

[morjesajesh]

What if the value of one of the columns in the array comes as null. How to handle that

[kavyamuniswamappa]

How to extract the data from Dataverse into xml file.. I have two dataverse tables related and I need to extract the data from both of them into xml.. is that possible?

[cedielaban]

Hi Paulie.
I wanted to understand more about this content.
I have this flow that I wanted to create. It involves a table coming from the body of an Oulook Email and tranferring the table data into MS Excel.
I hope you could help me!

Cheers! 🥂

[ubaltstudentsupport]

Would you mind posting the code? every time I try to get rid of the new line, it says my expression is invalid, and I'm not sure what I'm doing wrong. Thank you so much for posting this btw!!!

[gramos]

thanks, very nice. Now I need get data within excel, how to do it...¿?

[hotelranimahaljaipur]

@paluie M pls make video on power automate desktop (RPA) as i don't find good solutions available on youtube for that.

[kellymartinovitch]

I emails get everyday that contain tables, I need to track this table information in Excel, date, items, qty...etc. I've tried to follow along, but I don't code and this is so confusing. I really want to automate this process as it will be a huge time saver... can you help me?

[nilpr]

Hi Pauli, I am having SAP report coming in my email as an HTML file .htm extension. I want to conert it either in JSON or CSV or Excel so as to read it in dataverse. please guide

[kmgtizu]

Can you share your email id, i want to share my situation. I am working from last almost month to find out solution, its an HTML table i get from email which further need to add in Excel to create tracker. but when i convert html data into plain text it removes all the spaces between the Raws and den i lost to find further steps to proceed on.