Click on each hyperlink each row in Excel file

(0) Share

Report

Posted on by peterlongley

I am trying to automate the downloading of 2000 odd CVs which I have within an excel file, all set via hyperlinks.

Can you please advise how I could do this

e.g.

Cell A2 to A2057 contain hyperlinks I want to click on each of them which will prompt the downloading of the CVs accordingly.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Start by launching the Excel file, or simply attaching to the open window.

Then read the content.

When the content is read as a datatable, try downloading from web.

Was this reply helpful? Yes No
peterlongley 16 on at

Like (0)

Report
Copy link

Link copied!

Thanks I can get to Read from Excel worksheet and can see the 2057 rows and 1 column value.

But I am not following what you mean after that, For each what? and Download from the web asks for a website.

Sorry I am fairly new to Power Automate and thanks for your help

Was this reply helpful? Yes No
Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Add the For each loop action, then set %ExcelData% as the input. Each round the loop generates the %CurrentItem% variable, which you will use. If the link is a direct URL to a file, you can probably use the Download from web action, but if it the URL goes to a page that activates the download in some way, you will have to launch a browser, then navigate to that URL.

Stuff for you to look at:

https://learn.microsoft.com/en-us/power-automate/desktop-flows/use-loops#for-each-loop

https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#datarow

Was this reply helpful? Yes No
peterlongley 16 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help on this managed to work it out in the end, in case it helps anybody else this is how it ended up working for me.

Was this reply helpful? Yes No
thomasparker461 2 on at

Like (0)

Report
Copy link

Link copied!

Hey,
I am new to Power Automate as well, I just have one extra step I hope you can help me with it. Clicking on each link and then copying the data from that link clicked and storing it. Thank you so much for your help

Was this reply helpful? Yes No