Copy Hyperlink along with its text from Website to Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have several hyperlinks like these from a website:

I want to paste it in Excel as it is, without extracting the text and link separately.

I can do it manually by dragging that hyperlink from the website to the desired cell in Excel.

How can I achieve the same using Power Automate?

Insights would be very helpful, Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Use the Extract data from web page action, capture the elements with the hyperlink into a list, but when selecting what to extract, instead of "Own text" select the "href" atribute. This will return the hyperlinks into a list of values without the text itself.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I guess I wasn't clear with my question.

I want to paste the hyperlinked text as it is on an Excel Cell. In the image which I have attached the "1502149" is a hyperlinked text. I need to paste it in an Excel cell as "1502149" without losing its hyperlink.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Im interested to know what right click , copy would do. If that could then be pasted in Excel. The problem with drag n drop is that it’s multiple steps and harder to target than clicking on elements.

through @Agnius method, you could extract “Own Text” and “href” separately. Then paste the text and add the hyperlink; again, lots of steps.

if you are able to right click copy and then paste from clipboard to a cell, that should only be 3 steps. Right now, every solution is dependent on you being able to capture those elements or iterate through them.

they look like they are in a table, but I don’t think you will get the hyperlinks if you “get data from web element”. If the links are dynamic, it may be worth “get data” from the table and then use the column to iterate through and use the numbers to target the element(s). Then one of the 3 solutions above would be viable.

best of luck!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Only the link address can be copied with Right Click
But when I drag my mouse across the hyperlink and copy[CTRL + C], I can paste it on an Excel Cell:

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

The right way to do this would be to read both the text and the URLs via the Extract data from web page action and then use Run VBscript or Run PowerShell script to write the data into Excel while adding hyperlinks.

I would absolutely advise against using any keystrokes or mouse actions here.

See this for reference on how to use VBscript to create a hyperlink in Excel: https://www.kombitz.com/2006/02/28/114115852332316734/?amp=1
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I've found the solution and it was the most obvious one.

Used Extract Data from web page to extract text and URL separately in a data table.
Used Write to Excel Cell Action with value: =HYPERLINK("url", "text") in a for each loop iterating over the data table

Thanks for the insights guys! Appreciate it!

Was this reply helpful? Yes No