How to #PowerAutomate to parse and convert a HTML table to a JSON array for further use in your cloud flows. Once the HTML Table has been converted the data can be added to a SharePoint list, Dataverse or Excel table….(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Hi. First of all, thank you very much for a thorough walk of the process. I was struggling with this for a couple of days until I found your tutorial. For the step of mapping, I used a loop to dynamically create JSON items since the user might add stuff to the table and I didn't want my output to break because of that. So in my mapping in 'select;, I used this: split(item(),'^')[0], and element [1] as value. It worked for me, but I was wondering if there is a better way of doing this? Also a question. How can i return the JSON that i got after the 'select' action so i can use it further on?
Thank you Paulie, great stuff! Xpath to me is still 'black magic', but I will figure out more on this in future I guess.
why MS doesn't provide a html parser, all those steps just to convert html is timewaste.
Hello Paulie, I was following your video and doing step by step, everything was going well until I used the html to text connector.
I got this alert
"The flow was saved, but it couldn't be enabled because it contains connectors to apps that don't support the Gmail connector used in this flow"
Do you know of a way to do that step differently?
Thank you very much in advance for the video
How do I select the second table within the HTML list instead of the last table using the last expression?
Hello, Thank you for the video. It's very useful for me. do you have a video for importing a CSV file that contains special characters?
It took me 2 days but I got my slightly different tables and data to work thanks to this video
can you please add the content of saving data to excel table
Thank you for sharing your knowledge. Really helped me on my concepts. Thanks again!!
Fantastic video – many thanks for your help. And not too fast all!!
Hello Paulie thank you very much for this video. I'm new to power automate can you please advise me how can I select table 2 or 3 after the using the split?
Nice one Paulie, spot-on content 🙂
I have a question
Is it possible to extract from a .html file saved in SharePoint or email attachment .?
Many thanks
@Paulie M, I am very new to this and trying to get this output to Share point list, How to do it
Thank you so much, I was searching for days to find a solution for this
Thanks a lot. it helped me a lot in my learning period . I am new to power automate and it is in such more details explanation and with examples. which helped me in my project.
hi Pauli M,
What if I do not want to select the last table but the middle one. What command to use then?
Hi Paulie,
This was wonderful presentation unlike any other I have seen here. Have become a new subscriver now!
Just two important qs:
1) How do I remove any row during the 'Row' stage, For example I have one non-empty row in the end?
2) How can i append the output without the headers. Like I have already the headers in one excel file but simply want to append every output below the headers?
Thx!
Excellent video!!! Thanks. I watched another procedure but yours is quite simple and clear.
I rarely comment on people's videos but thank you so much for this VERY informative video. Whether you are a novice or need a refresher cuz you haven't done it in awhile (ME lol), this will help you with useful expressions which can be tricky at times. Thank you so much!!!
Hi Paulie, thank you SO MUCH for this video. I am brand new to Power Automate and have been trying to extract table data from hundreds of emails for WEEKS now. This video has solved my problem. I cannot thank you enough.
How would you grab the URL that is inside of the brackets instead of the text?
Incredibly helpful video
best video to learn power automate step by step, not only show the result, step by step to work out the solution love it
Great content!! What would you use if you only wanted to get first let say 5 rows from HTML table and ignore the rest?
Bravo!!! This works great for me …no issues! 🙂
Thank you very much, great explanation.
Hi Pauline, Great video. Just like others I'm also facing the same error The template language expression 'split(item(),'^')[1]' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Any suggestions?