Did an update break web data extraction?

(0) Share

Report

Posted on by CharlesBrewer

697

Hello,

I've had this flow running just fine for a while, it extracts several columns of data for a table on a website and manipulates the data. It's been fine, but the last 2 runs it has thrown this error :

Variable 'DataFromWebPage' must be a list, datatable or datarow.

Did something change? Thanks. I would assume it is a datatable already 😕

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Well, yes, an update to PAD could have broken something. That can sometimes happen. But it could also be that the web site changed. I would recommend running the flow in debugger and checking the variable value when the flow stops, to see what it has extracted. That could help figure out the cause of this.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

CharlesBrewer 697 on at

Like (1)

Report
Copy link

Link copied!

It wasn't the website, I did fix it. It was erroring out for the "for each row" step when analyzing the extracted data, when the data was empty and has 0 rows
And like I said it was working fine before. This is the 2nd time with this flow that an update has changed how it handles blank data and I've had to rework the flow. Luckily this one was easy, I just added this above it :
Now it seem to be okay.

Was this reply helpful? Yes No