Unanswered

Extract data from web page table use paging error

(0) Share

Report

Posted on by joelzehring

208

A desktop flow I'm working on uses the "Extract data from web page" action. I've configured the action to extract values from an HTML table with the advanced setting "Use paging" enabled.

In our production environment, this action works as expected, advancing through the pages of an HTML table and extracting the selected cells of each row. It was last updated with Power Automate Desktop version 2.26.139.22312.

In our development environment, the exact same action in the exact same flow is failing to advance through the pages of the HTML table. It's running with Power Automate Desktop version 2.27.177.22340. Here's the error:

"Problem while executing action 'ExtractTableUsingPagingFromAllPages'. Failed to extract data (web page error while extracting data)."

I'm able to log in and view this development version running, and it appears to be attempting to click the "Next" anchor element, as evidenced by a black outline around that element, but the web page doesn't update to the next page of the HTML table. It just stays at page 1.

Wondering if something changed in PAD around this action between the two versions above to lead to this error?

Categories:

Power Automate Desktop

All responses (2)

Answers (0)

Sort by

Laish_Glenberg 20 on at

Like
a
(1)

Report
Copy link

Link copied!

It's possible that you or your team might have to change the action you're using to 'click' the UI element to go the next page. For example, if using "press button on web page," try "press button in window," and if that is still throwing errors try the "move mouse to image or text on screen (with OCR)."

If none of those solutions are working you can set an action to repeat itself on an error, use the wait action, or even increase the run delay milliseconds. Please let me know if this helps.
joelzehring 208 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up disabling the built-in "Use paging" feature of the "Extract data from web page" action. Now, the action runs inside a while loop and checks at the end of each iteration to see if the "Next" link is still present. If the link is still present, I'm using a "Click link on web page" action to advance to the next page of the HTML table. If not, the while loop terminates.

It works, but it's a lot of code to implement functionality that seems to be built-in to an action in a previous version of PAD.