Power Automate Desktop Web Automation | Extract data from web page | Web Data Extraction | Part 1

hi guys welcome to web automation part 1 tutorial in par automate desktop today i will explain how to perform web data extraction so let's get started for today's demo i'll take this amazon website well let's say that i search for iphone 11 and here is the search result now for each of these iphones there is a description and a cost now let's say that our requirement is to extract this description and cost of all these iphones across this page so let's create this flow in power automate desktop so for that i'll move to power automate desktop and create a new flow let's give a flow name here web automation web data extraction and let's hit on create now here if you move to actions there is web automation where multiple of actions are listed to perform web automation on a browser but to work on any browser using par automate desktop the par automate desktop extension need to be installed on that browser let's say that you want to work on chrome browser using par automate desktop so let me tell you what to do to do so so for that you will move to tools browser extensions and choose your required browser from here since i wish to work on chrome browser i'll go with the google chrome and here we are in the chrome web store this is the microsoft power automate extension let's hit on add to chrome and hit on add extension and here it says the power automate has been added to chrome so this extension that is microsoft power automate extension has been added to chrome now you are good to work on chrome browser using power automate desktop in a similar way if you wish to work on other browsers you will follow the same process so let's move to par automate desktop again and here for our flow first of all we will launch the browser now the power automate desktop supports internet explorer firefox chrome and edge let's go with the action launch new chrome to work on the chrome browser so drag and drop it to the main panel and here let's select the launch mode so let's select the launch mode as launch new instance and provide the initial url here so we'll provide the initial url as this one let's provide the url here and let's choose the windows state so you can choose the windows state either as normal maximized and minimized let's go with the maximized option and under the enviro advanced settings we can clear the cache and cookies and also we can turn this on to wait for page to load so let's go with this turned on option of to wait for page to load also this action produces a variable that is browser which is a chrome instance to be used with web automation actions so let's hit on save and accordingly the browser variable got listed under the flow variables now let's extract the data from this web page now to extract the data from the web page will expand this web data extraction where this there is an action to extract data from web page so let's drag and drop it to main and here it took the web browser instance now to extract the data from the web page let's move to the web page where you will get this live web helper window which will be used to extract data from the web page so what you need to do mouse over to the element which you wish to extract and once you get that element surrounded by this red rectangular box right click on that element and select this extract element value and since we wish to extract that text of this element so let's click on this text so you see here the description got extracted in a similar way we will extract the cost so mouse over to the cost and it is surrounded by this red box so right click on that select extract element value and select the cost so you see here the two values got extracted value one for description and value two for cost so as of now we extracted the description and cost for one iphone but we wish to extract the description and cost for all the iphones across this page so to do so what you will do you will follow the same process for the next iphone element so i'll mouse over to this description and it has been surrounded by this red box so right click on that extract element value and select this text now as soon as you do so bar automate desktop is intelligent enough to extract the description and cost across the entire page so you see all the values of description and cost for all the iphones on this page got extracted now after the extraction there are some advanced settings so let's move to advanced settings where you will get the css selector of the elements which you extracted so you can go with this css selector as well or you can modify the selector as per your requirement now next if you wish to extract the data across multiple pages you can turn this on use paging and you can provide the css selector for next page of search results here as of now let's turn this off we'll extract the description and cost across this single page so this is the advanced settings let's hit on ok and we are done with the extraction so let's click on finish and again we are navigated to this power automate desktop this extract data from web page action now our next parameter is store data mode so you can store the data which will be extracted either as a variable or as an excel spreadsheet let's take this excel spreadsheet we'll store the extracted data in our excel spreadsheet so let's select this one and since we selected excel spreadsheet this action will produce the variable excel instance which will be used in the later x elections so let's hit on save and with this we extracted the data from the web page now at the end we'll have to close the browser as well so for that i'm going to use the action close web browser let me add it here and it took the web browser instance as browser let's hit on save and since the extracted data will be stored in an excel file at the end we'll have to save and close that excel file as well so i'll use one excel action as well so let's move to the excel and let's use this close excel action so let me add it here it took the excel instance as the excel instance variable which got created in this previous action and before closing the excel we wish to save the document so let's select save document as and here we'll provide that document format as xlsx and here we'll provide the document path so click on this select file and i'll store the excel file in this location let me provide the file name here extracted data and let's hit on open and let's hit on save so our flow is ready it's going to launch the chrome browser and extract the data from the web page and at the end it's going to close the web browser which got opened and after that it is going to close the excel as well it is going to save the extracted data into the excel and close the excel file so let me save this one let's hit on ok and let me close this browser as well power automate desktop is going to open it on its own and let's quickly run this flow and my project is running now it is launching the amazon website and now it is going to extract the description and cost from this web page and store it in excel file and the execution is over let's quickly move to our folder location and here you see this is the extracted data file which got created let me open this file and here you see the complete description and cost across the page got written inside this excel file so in this way you can extract the data from web page using power automate desktop with the action extract data from web page this action is used to extract data from web page using par automate desktop in the form of single values list rows or tables in the next session we will take a look on how to fill forms under web application using another web automation actions under web form filling and that's all for this session guys i hope you enjoyed this video and if you did give it a like and share with your friends hit the bell button to get the updates on the latest videos and if you have not yet subscribed to our channel please subscribe to our channel as well and i'll see you soon in the next one bye bye

Channel: Quality Assurance Lab

Views: 27,037

Keywords: power automate desktop web automation, power automate desktop web scraping, power automate desktop web data extraction, power automate desktop web browser instance, power automate desktop web recorder, power automate desktop web, Extract data from web page, Web Data Extraction in Power Automate Desktop

Id: T06nQIBjssc

Length: 10min 3sec (603 seconds)

Published: Wed Mar 31 2021