web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to convert http re...
Power Automate
Unanswered

How to convert http result?

(0) ShareShare
ReportReport
Posted on by

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)
  • efialttes Profile Picture
    14,756 on at

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard