Extracting table from Website

I am not new to UIPath, just rusty. I created a process that goes to a website and extract data but I need a few tips on making it work.

  1. how do I loop through the links on the search page?
  2. when it extract to excel, it is pulling the information twice, and when it transpose to excel, it is repeating the column heading

the website I am trying to pull data from is: http://www.tsbpa.state.tx.us/php/fpl/frmlookup.php
Any help would be greatly appreciate.

Hello @uidonna.jonnes

I don´t see any bug, can you please share the XML? it would be easier to review and help…

regards

Main.xaml (42.9 KB)

Is this what you need?

1 Like