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

Note: This method works only when table rows and columns are static (Not values)

Follow the steps below

WebAutomation.LaunchEdge.LaunchEdge Url: $'''https://rpademo.automationanywhere.com/itbricks_enroll.php''' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: 60 Timeout: 60 PiPUserDataFolderMode: WebAutomation.PiPUserDataFolderModeEnum.AutomaticProfile BrowserInstance=> Browser
WebAutomation.ExtractData.ExtractTable BrowserInstance: Browser Control: $'''html > body > form > center > table > tbody > tr''' ExtractionParameters: {[$'''th:eq(0)''', $'''Own Text''', $'''''', $'''Value #1'''], [$'''td:eq(0)''', $'''Own Text''', $'''''', $'''Value #2'''] } PostProcessData: True TimeoutInSeconds: 60 ExtractedData=> DataFromWebPage
WebAutomation.CloseWebBrowser BrowserInstance: Browser

Quick Links

Leaderboard