Extract Data From a List of Webpage Pop Up Windows

[macdonal_T]

Hello,

I am trying to create a flow that extracts data from a data table on a webpage. My issue is that the data I am trying to extract lies within a pop up window that shows up when you click on the data table cell. I have tried the "extract data from webpage" as well as the "extract data from window" tools but neither work. I have managed to get the idea running with a loop involving pressing the down arrow on my keyboard, but it runs fairly slow and it does not end with the end of the data table, only a certain number of loops. I have attached a picture of the the data table when a cell is pressed creating a pop up window, and a picture of my current loop for extracting the data. For reference, it is the email on the pop up window that I am trying to extract. Any help at all would be greatly appreciated. 

[macdonal_T]

[eetuRobo]

So does the extract data from a web page -action not work at all on the pop-up window where you need get the email? Or is the problem that you would want it to get all emails from every item of the data table? If its the latter then I think you way of going through each of them one by one is the only way unless you can customize the data table to show the emails in the main data table(before having to click a row to open the popup)

For the loop count. When you use the Extract data table from web page -action does it return the full datatable? If so I would change the items per web page to maximum

and if that shows all the items in one page then use the Extract data table from web page -action and store it into a variable. Then in your loop use DataFromWebPage.RowsCount 

[macdonal_T]

Yes the issue is I want to extract the email from every cell on the data table. The extract elemnt from webpage tool works for 1 email on a pop up window, but nothing more. The Data variable replaces the previous email when another is extracted. So right now I have it extract the email, write it excel, then move to the next email and loop that. My issue with that is that it is quite slow.

[eetuRobo]

Can you customize the main table:

To show the email address? If not I think you have to just accept it being slow since you have to go through each row one at a time to open the pop up window and extract the email address from it. If the data is inside the row item then the Extract data from web page -action can't get that data since its not visible. 

To add the email column maybe try pressing the settings icon at the top right corner:

And see if there is option to add the email column from there. So then if you are able to see every rows email without opening them then you can extract them all in one Extract data from web page -action.

If not then you just need make as fast as possible loop. So as few actions inside the loop as possible. 

[macdonal_T]

I have tried every possible way to get the email to show without pressing the data cell, but unfortunately there is no way to do that. Any recommendation on how to make my loop I shared earlier in the chat run faster? I cannot think of a way to make it shorter than using those 4 actions.

[eetuRobo]

You could delete "Send keys" -action for Excel and have the "Write to Excel worksheet" -action determine which row to write the value. So Write mode: On specific cell and Row being %LoopIndex%

Then you don't need to send keys down on the excel. So then you have it down to 3 from 4 actions.

Send keys "Delay between keystrokes" option you can also decrease from the default 10 to 1 for example but that could add unstableness to the flow.

Also if you run the flow from the edit mode then put Run delay on 1.

Other than that not much I can think of. Since it will have to go through every row it will naturally take some time.