Citizen Developer
Timespan
explore our new search
​
Web scraping via Power Automate Cloud Flow
Power Automate
Sep 12, 2022 10:23 AM

Web scraping via Power Automate Cloud Flow

by HubSite 365 about Damien Bird

Power Platform Cloud Solutions Architect @ Microsoft | Microsoft BizApps MVP 2023 | Power Platform | SharePoint | Teams

Citizen DeveloperPower AutomatePower SelectionM365 Hot News

Looking to scrape data from a website using Power Automate? In this demo I build the flow step by step, showing you how we can retrieve an html table from a website and convert it to XML and JSON.

Looking to scrape data from a website using Power Automate? In this demo I build the flow step by step, showing you how we can retrieve an html table from a website and convert it to XML and JSON. I then extend the solution to show you how easily it is to pass that array to Power Apps, save as a collection and display in a Gallery.

In this video

  • Using HTTP Action in Power Automate
  • IndexOf to get Table Tag Position
  • Retrieving the HTML Table
  • Converting HTML to XML and JSON
  • Reporposing an array using Select
  • Responding to Power Apps with an Array
  • Connecting Flow to Power Apps
  • Displaying Flow Array in Power Apps
  • Outtro

We value your privacy

This website stores data such as cookies to enable important website functions as well as marketing, personalization and analysis. You can change your settings at any time or accept the default settings. privacy policy.