Extract data from web page Action(Power Automate Desktop)

Japanese version.

This action retrieves data from a table on a web page.

The format of the retrieved data can be a Data table or Excel.

This action targets the browser launched for automation with the following actions.

How to use

First, open the page to be retrieved.

Then, under "Browser automation" and "Web data extraction", drag "Extract data from web page" and place it below the browser launch action.

Set parameters.

Select the previously opened page with the table you wish to extract.

The following window will then appear.

In this state, right-click on the table from which you want to retrieve data and select "Extract entire HTML table".

If there is page switching, right click on the link or button that takes you to the next page, and select "Set Element as Pager" from the menu.

If the setup is successful, the contents of the table will be displayed, Click "Finish" in this state.

Parameter

Web browser instance

Specify the target browser (Variables produced by the startup action).

The table to be retrieved must be visible in the specified browser at the time the action is executed.

Extract data from

If a pager is set up, specify how far to extract.

All available

Retrieve from all pages.

Only the first

Specify the maximum number of pages to be retrieved for the "Max web pages to process" parameter.

Process data upon extraction

Turn ON when you want to reflect the filtering results in a table with filtering functions.

Basically, it can be left off, which is light in operation.

Timeout

Specifies the number of seconds until timeout.

If the extraction is not completed within this number of seconds, the action will result in an error.

Normally, there is no need to change this value, but if you are extracting large amounts of data, you may need to increase this value.

Store data mode

Specifies the format of the data acquisition results.

Variable

Retrieve results in a Data table(variable name DataFromWebPage).

Excel spreadsheet

Get the result (variable name ExcelInstance) in Excel.

In many cases you will use Close Excel to save the file as a file.

For those who want to learn Power Automate Desktop effectively


The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.

Table of Contents.

Update History.

Links

Browser automation Actions