Power Platform Community Forum Thread Details

I have 3965 records to extract, with 20 records per page. I attempted selecting "All Available" from the dropdown menu, but it always results in an error and loops through infinite pages without extracting any data.

I also tried specifying "31" as the number of pages, but each attempt yields inconsistent results: sometimes the next page gets clicked 73 times, other times it goes into an infinite loop.

When I set the page number to "30," it correctly extracts the data but still clicks through extra pages inconsistently, varying with each attempt.

please guide

Categories:

Building flows

Could you share the site so we could try to solve the problem easier (if its not sensitive data or its not behind some user credentials)? Or find an example site that gives same issue so we could recreate the scenario and debug it?

I tried with this demo site which has much less data DataTables (table plug-in for jQuery) and it seemed to work fine.

It sounds like "Extract data from web page" -action does not recognize which page its in the page you are automating. And thats why it keeps going to the next page. So I think only way is that you toggle off the "Use paging" in Extract data from web page - advanced settings and create the paging loop your self.

So extract only the one visible table and add it to your datatable and go to the next page and repeat. Like so: