web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to convert http re...

Power Automate

Unanswered

How to convert http result?

(0) Share

Report

Report

Posted on by dwwer

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

efialttes 14,756 on at

Like (0)

Report
Copy link

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

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

Was this reply helpful? Yes No

Join the conversation