You’re offline. This is a read only version of the page.
Hi, I use Http get request and as a response i have html type.
<!doctype html>
<title>test</title>
<div class=page>
<table>
<TR>
<TD>id</TD>
<TD>naming_convention</TD>
<TD>headline</TD>
<TD>headline_translated</TD>
<TD>status</TD>
...
How can I convert or transfer response to upload values to excel table
Hi!
Power Automate is probably not the best tool for web scraping.
You can probably use WDL functions to manipulate the HTML in order to get all the stuff in between <table> and </table>. Then:
-If the table is simple, and properly defined, convert it to xml and use xpath() to extract all its rows, or
-You can also use 'HTML to text' and manage the following expression to convert its output into an array, each element a cell
Share
Report
All responses (
Answers (
14,756
split(trim(uriComponentToString(replace(uriComponent(body('Html_to_text')),'%0A','~~'))),'~~')SEcond approach is simpler to implement in my opinion. FRom my little experience, none of them guarantee a 100% success
Hope this helps
