How to convert a HTML Table to JSON with Power Automate

[@luciozanarotto1974]

Great video Paul, for a scope that seams esay, but not. Thanks a lot!

[@hostile_technics]

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

[@PaulieM]

Glad it was helpful to you.

[@luisvallejosloconi9328]

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

[@PaulieM]

Thank you Luis - lots more content coming soon!

[@anniekostadinova7915]

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.

[@PaulieM]

My pleasure, should be a new one coming today. If you have something you’d like to see explained let me know and I will try to cover it.

[@anniekostadinova7915]

@@PaulieM I'm trying to use MS Forms and all responses to fill out in a PDF template. Is that possible?

[@PaulieM]

@@anniekostadinova7915 yes, it’s possible. Do you have a Power Automate Premium license?

[@anniekostadinova7915]

@@PaulieM yes, I do

[@PaulieM]

@@anniekostadinova7915 we can build it together if you like. Record it and I will publish as a KZbin video 👍🏻

[@aliyusx]

You are a real hero! A real one!

[@PaulieM]

Ha ha, thank you!

[@davidnjoroge9314]

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?

[@kenhardin]

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

[@Plonoord]

This video helped me a lot, thank you Paulie

[@ahtiblumkvist-du7jf]

Hello, Everything else works, except for when you filter out the empty variables from array. For some reason, when i put in the filter, it says Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(lenght(item()), 0)' failed: 'The template function 'lenght' is not defined or not valid.' Instead, i used Filter array expression @equals(empty(trim(item())), false), which works beautifully. Not sure why the lenght variation doesn't work.

[@babypooful]

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

[@usiala]

Thank you for Sharing, great content.

[@PaulieM]

My pleasure, glad you found it useful.

[@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?

[@dushy4486]

Thank you so much dude. It resolved my issue

[@PaulieM]

Very happy that you got the solution you needed.

[@arshad801]

Amazing stuff..thnx for sharing

[@PaulieM]

Thank you!

[@morjesajesh78]

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

[@ubaltstudentsupport4544]

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!!!

[@kellymartinovitch2034]

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?

[@PaulieM]

If you get in touch via my blog I will see if I can help you sort it.

[@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

[@PaulieM]

Which part of the video was unclear - where are you stuck?

[@nilpr]

@@PaulieM the attachment I am getting is SAP report of more than 10MB and HTML to text doesn't work for this much file size; so at first step itself I am stuck.

[@PaulieM]

@@nilpr You will probably need to do some operations on the file before you can work with it. This is a more complicated scenario. You will need to reach out to me via my blog.

[@cedielaban3410]

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! 🥂

[@PaulieM]

Which part are you stuck with?

[@gandalf1940]

Very very nice, thank you very much!

[@PaulieM]

You’re very very welcome!

[@gramos73]

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

[@hotelranimahaljaipur9380]

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

[@Jyoti-h1h]

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.

[@PaulieM]

There is a get in touch form on my blog.