Extract data from a webpage

(0) Share

Report

Posted on by timothy_maina

Hey community, I need help to extract the entire HTML table from this webpage...

Can someone give me a guide to extract everything from the table since it is an URGENT task to done

The webpage:🙄

https://www.mgs.net.au/auction/catalogue.html?d=3484

Categories:

Power Automate Desktop

All responses (8)

Answers (3)

Sort by

Verified answer

eetuRobo 4,587 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Copy and paste this to your flow:
WebAutomation.LaunchChrome.AttachToChromeByUrl TabUrl: $'''https://www.mgs.net.au/auction/catalogue.html?d=3484''' AttachTimeout: 5 BrowserInstance=> Browser WebAutomation.ExtractData.ExtractHtmlTable BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div > table > tbody > tr > td:eq(1) > table:eq(0)''' ExtractionParameters: {[$'''Value #1''', $'''Value #2'''], [$'''''', $''''''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> DataFromWebPage WebAutomation.ExtractData.ExtractHtmlTable BrowserInstance: Browser Control: $'''html > body > div:eq(0) > div > table > tbody > tr > td:eq(1) > table:eq(2)''' ExtractionParameters: {[$''' ''', $'''Lot''', $'''Qty''', $'''Description''', $''' (1)'''], [$'''''', $'''''', $'''''', $'''''', $''''''] } PostProcessData: False TimeoutInSeconds: 60 ExtractedData=> DataFromWebPage2

Or take the elements yourself with "Extract data from web page"
timothy_maina 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey I have tried extracting the elements but It is taking the first 20 only
timothy_maina 20 on at

Like
a
(0)

Report
Copy link

Link copied!

How to I copy paste to the flow...
Am a newbie so🤔
Verified answer

eetuRobo 4,587 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Just simply highlight the code and Ctrl + C and then in your PAD flow paste it with CTRL + V

Ctrl + C

Ctrl + V

As you can see in my first message I was able to get all 800+ rows
timothy_maina 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Let me do it...
Then would like the data to be saved to spreadsheet...
How will I do it please
Will all the data appear at the worksheet...
Verified answer

eetuRobo 4,587 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Change the Store date mode: to Excel spreadsheet.
Then it opens Excel and puts the data there.
timothy_maina 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Great... What if I want to insert with images embedded on it
Like this ones
timothy_maina 20 on at

Like
a
(0)

Report
Copy link

Link copied!

This is how the spreadsheet looks like....Thanks a lot!!!
The data is inside....