Example of how to convert a HTML Table to JSON in Power Automate, answer to Power Automate community question: powerusers.mic... If you found this solution useful, I'd appreciate a donation to the channel: www.buymeacoff...
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?
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.
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! 🥂
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?
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!!!
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?
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 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.
@@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.
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.