This action retrieves data from a table on a web page.
This action targets the browser launched for automation with the following actions.
- 1. How to use
- 2. For those who want to learn Power Automate Desktop effectively
- 3. Links
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.
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.
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.
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.
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.
Retrieve results in a Data table(variable name DataFromWebPage).
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.