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

32840d42f3b08a741...

b6936eae749dcbced...

I have the same question (0)

All responses (26)

Answers (2)

Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Milanomaa 10 on at

Like (0)

Report

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.

7452cbe2829f8b873...

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Pavel_NaNoi 1,074 on at

Like (2)

Report

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:

Was this reply helpful? Yes No
Verified answer

Highboy 1,183 Super User 2024 Season 1 on at

Like (0)

Report

Wow well done 😊

Was this reply helpful? Yes No
Milanomaa 10 on at

Like (0)

Report

It worked exactly how i want. Thanks a lot @Highboy

Was this reply helpful? Yes No
Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Sandy84 38 on at

Like (0)

Report

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.

Page 1.png

Page 3.png

Page 2.png

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sandy84 38 on at

Like (0)

Report

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.

Was this reply helpful? Yes No