To utilize the “Extract data from web page” action in Power Automate Desktop, you need to drag it onto the workspace and then switch to the specific screen from which you want to extract data.

This action operates differently from other actions within Power Automate Desktop.

In this article, we will use data from website List of most-watched Netflix original programming which includes 2 tables that we aim to extract.

• Table 1 is intended for utilizing the “Extract entire HTML table”
• Table 2 is intended for utilizing the “Extract element value”. We will focus on extracting only two specific columns from Table 2.

Launch new Chrome

Launch mode: Launch new Instance

Initial URL: https://en.wikipedia.org/wiki/List_of_most-watched_Netflix_original_programming

Extract data from web page 1

Drag “Extract data from web page” action and drop to Power Automate Desktop’s workspace, then switch screen to wikipedia, the new window name “Live web helper” will appear.

You can move mouse to the table that you want to extract data, when the red frame cover the table right click and select Extract entire HTML table

Web browser instance: Browser variable

Store data mode: Variable

Note You can change “Store data mode” from “Variable” to “Excel spreadsheet” and save as new Excel file

Check Result (Table 1)

Run and check details. The results will be 15 Rows, 6 columns (Retrieved data on 17 May 2024)

Double click the variable “DataFromWebPage”, the result in Power Automate Desktop will slighly differnt from website wikipedia due to merge cells in website. Therefore you have to check data before proceed next step.

Extract data from web page 2

Drag “Extract data from web page” action and drop to Power Automate Desktop’s workspace, then switch screen to wikipedia.

Move mouse to the table cell in table 2, when the red frame cover the table cell right click and select Extract element value > Text (This time will select 1st rank data cell in “Title” column)

Move mouse to 2nd rank data cell in “Title” column, when the red frame cover the data cell right click and select Extract element value > Text

Power Automate Desktop will automatically find patterns on websites. The extracted data will be displayed in the Live Web Helper window.

Move mouse to 2nd rank data cell in “Hours watched” column, when the red frame cover the data cell right click and select Extract element value > Text

Power Automate Desktop will automatically find patterns on websites. The extracted data will be displayed in the Live Web Helper window.

Check Result (Table 2)

Run and check details. The results will be 21 Rows, 2 columns (Retrieved 5 Jun 2024)

Double click the variable “DataFromWebPage2”, the result in this variable will missing 1 value as per highlight.

As per above, go to inspect an element on Wikipedia. Right-click and select ‘Inspect’. You will see different tags in the HTML code.

Therefore, we need to change the position for extraction by clicking on the table cell in the Title column instead.

Run and see result

Completed flow

You can copy the source code of this article from github and paste it into your Power Automate Desktop’s Workspace.