Failed to extract data (web page error while extracting data).

(0) Share

Report

Posted on by NandorR

Hi!

I am currently trying to do a webscraping flow to copy data in a table to an excel file:

I used Recorder to identify which data to copy and I selected to extract HTML Table
However when the flow completes, there is no data in the excel file.
When i look at the Flow Variable itself, there is no values at all refer to pict below.
Has anybody ever encountered such an issue before, and how do I resolve it?

Categories:

Power Automate Desktop

All responses (24)

Answers (0)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you please share the PAD script you are using?
NandorR 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ankesh_49,

Thank you for the response! I am pretty new to PAD, so may I know what is the script you are referring to? Is it the screenshot below?
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Works fine.
Could you please share the Web url, you are using for data extraction.
NandorR 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ankesh,

I am unable to share the URLas it is a company intranet link. Is it possible that the intranet website is the reason why PAD is unable to pull anything?
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Not at all.

Could you please try adding a delay after step 11 in your script.
Also, could you please confirm if you are getting below option while doing a record

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandorR

Instead of the recorder use the "Extract data from web page" action.

Also see on which Html tag are you selecting the "Extract entire html table"?

For example in this case I am doing it on the <th> tag and then able to see the columns in the preview section on the right.

Likewise play around and see which one works for you.

Sometimes it is also the <table> tag.
NandorR 16 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

My answer to your comments in blue:

Could you please try adding a delay after step 11 in your script. Performed but still got the same results)
Also, could you please confirm if you are getting below option while doing a record (i did get that same option when i used the Recorder function. However when i clicked it, and ran the flow, the variables were still empty)
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@NandorR Could you please check if you are using correct browser instance? %browser2% or %browser1%.

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
NandorR 16 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi VJR,

Thank you for your response. My answer to your comments in blue:

Instead of the recorder use the "Extract data from web page" action. (For some reason this doesn't seem to work for me, when i select "Extract data from web page" it cannot seem to recognize any of the elements in the web page, though could it be due to lag as I am using it on MS Edge?)
Also see on which Html tag are you selecting the "Extract entire html table"? (For this case i selected <td> it still returned a blank table when i ran the code, when i originally selected <table> it still yielded the same issue. though i will try clicking on other types of tags to see if it works. Also it should be noted, I originally selected specific elements in the web page, the flow variables still showed blanks.)
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandorR Is this webtable inside some webframe?