Power Platform Community Forum Thread Details

Cannot get "Extract Data From Web Page" to extract 2 elements from ALL rows in an html table.

I am attempting to use the Extract Data From WebPage action in a desktop flow to extract a single column from an html table into a datatable. I'd like to get the Text of the column along with the href attribute of the column (which contains an <a> tag within a <td> tag. There are several hundred rows in the table. I attempt to the the live web helper to right mouse button and select first the text element and then the href attribute of the <a> tag. That seems to work but it only ever extracts a single row from the html table when i run the flow. How can i get all rows to be retrieved ? See screen shots for the html table and anchor tag that is the source of my data extract. According to chatgpt, i should see an option as i'm building the flow that allows me to designate all rows in the html table, but power automate desktop is not prompting me for that and ends up limiting itself to 1 and only 1 row from the html table. pretty new to automated data flows, so any help would be appreciated. thanks.

Categories:

Process Advisor

Usually if you capture more than just one row in the Live web helper then it automatically gives you all the rows in that column.

So here I already have captured the first row and now I am capturing the second row:

After giving it just two rows it gave all the rows in that column automatically:

Then just press Finnish and save the action and run the flow.

Sometimes it might give you the whole table and not just the one column but then I would advise to just use "Retrieve data table column into list" -action if you need only the one column and not the whole table.

Video to help: https://www.youtube.com/watch?v=L6kSQ4hzMco
Documentation (at the bottom there is some paragraphs about "Extract Data From Web Page"): https://learn.microsoft.com/en-us/power-automate/desktop-flows/automation-web

Quick Links

Leaderboard