Read data from Excel, Search in Web, get whole datatable and Write in Excel

Hi,
Please see my below screenshot of my project.
I’m trying to read data from excel and use the data i read to search in Web, and then get the datatable from the searched result and write into Excel.
The problem i facing is I can only get the 1st search product and store in Excel, i can’t get 2nd, 3rd product & etc… into Excel. Please assist my issue. Thanks.

CanInsertToExcel.xaml (16.4 KB)

In case you guys need the file, I have uploaded.Thanks.

Hi @ack940129 :wave:

The reason you are not able to process the 2nd and 3rd items is because you didn’t navigate back to the home page where you are performing the search.

You can do 2 things here:

  1. Use a Close Tab activity to close the tab where you are extracting the DT.
  2. Use a Navigate To activity to navigate back to the home page.

Kindly try it and let me know if you are facing any issues.

Cheers!

Hi,
Thanks for the reply.

I have another issue which is cant capture the correct data, i saw that the validate is in red, how can i solve this?

image