Pagination error

(1) Share

Report

Posted on by Milanomaa

I just want to extract multiple tables from different pages of same website. I did following process

1) "Lunch new firefox": and assign this website '''https://www.nepalstock.com.np/floor-sheet

2)"Extract data from webpage": I select extract entire HTML table and "Set Element as pager". However its not working as it extract only 1st page( I tried "all available pages", "only first page"etc. But not working as it is extracting only one page.

When i run second variable only, it shows " Argument 'BrowserInstance' must be 'Web browser instance'

I am very new on this field, pls guide us somebody.

Thank you

Categories:

Power Automate Desktop

All responses (26)

Answers (2)

Sort by

Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you give me an example with data on the webpage?
Show me a picture of what you are trying to extract.
Milanomaa 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to extract data of https://www.nepalstock.com.np/floor-sheet.
It display 20 line item on time, but there are 2934 pages.
Picture attached is one page, i want all pages to be extracted
Please help me on this.
Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm have tried lots of different selectors, and it should work, but as you have noticed yourself, it does not work.
It should, but dont 🙄

I have no idea why.

If I find it, I will tell you.
Verified answer

Pavel_NaNoi 1,074 on at

Like
a
(2)

Report
Copy link

Link copied!

Its because the pager needs a "span" element, but its hidden under the "a" selector for the pager, to fix this, go to the advanced settings, and simply put a "> span" at the end of the pager selector, like so:
Verified answer

Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow well done 😊
Milanomaa 10 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked exactly how i want. Thanks a lot @Highboy
Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

I can't take credit for the solution.
It was Pavel_NaNoi who solved it.
Sandy84 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Pavel_NaNoi, I have a similar problem, but in my case its not giving me any error but only capturing the data from the first page and stops, I recently updated my Power Automate Desktop Ver to 2.30.109.23075 and my Script has stopped Paging function, Now as I am changing the pages the element for the Paging selection is not at the same place ...

On the first page the CSS Selector code is html > body > main > div:eq(1) > div:eq(4) > div > div:eq(0) > a:eq(6)

On the Second page the CSS Selector code is html > body > main > div:eq(1) > div:eq(4) > div > div:eq(0) > a:eq(8)

On the Third page the CSS Selector code is html > body > main > div:eq(1) > div:eq(4) > div > div:eq(0) > a:eq(9)

and so on, can you please help me on this ... I have attached the screenshots as well, do let me know in case you require any additional details.
Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

I think in your case all you have to do is remove the ":eq(#)" at the end of a, so that it looks like this:
html > body > main > div:eq(1) > div:eq(4) > div > div:eq(0) > a
this will make it generic, and it should always select the pager no matter what.
Sandy84 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thanks for replying ... I changed the code as mentioned but now it is only repeating the paging by clicking on 1 and copying the same data repeatedly.