From Excel Column URL to opening sites

[Anonymous]

Hi - I am trying to open /click rows in an excel with URL link. I need to extract that data once the URL is open pasting it back to to the corresponding row. Anyone has done something similar?

[fraenK · Accepted solution]

You need to open Excel with your file, read its content, oprn a browser, loop through each row?, open the cell value as URL in a browser, extract your data and write it back to Excel to a named or numbered cell

https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-type...

https://docs.microsoft.com/en-us/power-automate/desktop-flows/automation-web

[Anonymous]

Hey, is there any more possible information on how to solve this. I have read through links provided by fraenK and I am still struggling to complete the same job as Anons post. Working through a list of URLs within excel, extracting info from selected URL and writing data onto the next column (Looping through each row intillfinish). Any simple guided templates would be greatly appreciated.

[MichaelAnnis]

Assuming you are doing this in chrome:

• Open Excel
• Get Last Row
• Get Exceldata (to last row)
• For Each %CurrentItem% in ExcelData #Current Item = Row in this case
  • Read %URL%
    • If %CurrentItem.Index% (or .Row - not sure) = 1, Launch Chrome to %URL%
    • Else
      • Focus Chrome Window
      • Send Keys {Control}(l) #that's a lowercase L - this will take you to the address bar
      • Send Keys %URL%{Enter}
    • EndIF
  • Do your tasks to find your info
  • Write to Excel
• End #For Each

Best of luck!

[Anonymous]

Thank you so much! I'll make sure to update you when I have it working

[Anonymous]

An Error is thrown on action 9 (Focus window) Window instance must be an integer value? 

[Anonymous]

Hello @Anonymous 

Here is working example of desktop flow.

Excel.LaunchAndOpen Path: $'''C:\\Users\\User01\\Documents\\Open URL to Get Infor from Web.xlsx''' Visible: True ReadOnly: False LoadAddInsAndMacros: False Instance=> ExcelInstance
Excel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
SET RowIndex TO 2
LOOP FOREACH CurrentItem IN ExcelData
    WebAutomation.LaunchEdge Url: CurrentItem['URL'] WindowState: WebAutomation.BrowserWindowState.Normal ClearCache: False ClearCookies: False Timeout: 60 BrowserInstance=> Browser
    WAIT 2
    WebAutomation.DataExtraction.GetDetailsOfElement BrowserInstance: Browser Control: appmask['Web Page \'h ... nd-august/\'']['Author and Publish Date'] AttributeName: $'''Own Text''' AttributeValue=> AttributeValue
    WebAutomation.CloseWebBrowser BrowserInstance: Browser
    Excel.WriteCell Instance: ExcelInstance Value: AttributeValue Column: 3 Row: RowIndex
    Variables.IncreaseVariable Value: RowIndex IncrementValue: 1 IncreasedValue=> RowIndex
END
Excel.CloseAndSave Instance: ExcelInstance

Thank you.

[Anonymous]

Fantastic!  Works perfectly Thank you!

[Highboy]

Could be even faster if you move the "Launch new Microsoft edge" up before the for each
The use "Go to webpage"  inside the "For each" loop
Then when the loop finish, close the web browser.

In that way you don't have to start and close the web browser all the time.

[Anonymous]

Hello @Highboy 

You are right. Thanks for your advice. 😊

[Powerlearnerd]

@Highboy  do you know how can I complete this flow by using extracting data from webpage instead of get details of element on web page

[Highboy]

Not quite sure what you are asking for.

[Powerlearnerd]

@Highboy Thanks for your quick reply. 
I have an Excel file with the following URL's 

I want to open each of these websites and then webscrape multiple items on the pages.

E.g. contact details for multiple dealers.

Many thanks in advance

[Powerlearnerd]

Hi @Highboy , do you might have an idea on this.

Kind regards

Powerlearnerd

[Highboy]

A quick solution would be something like this

[hello2]

@Highboy hello high boy,

i am having issues with following this. Attaching the issue and my doc here. thanks for much in advance for your help.!

[Highboy]

Replace %20 with %%20

[Highboy]

Ahhh can I have the excel file and the code, then I wil test it or we can take it online if you want