It seems like @trice602 has misread your question, as this is related to retrieving URLs from an Outlook email and not an Excel file.
I can see you mentioned several hyperlinks in a single email. I would guess you use a Retrieve email messages from Outlook account action to retrieve your email messages. When you do that, you end up with a list of email messages stored in %RetrievedEmails% variable.
I would suggest you use a For each loop on that list, so you are working with a single item at a time. You can then use %CurrentItem.Body% to get the body of the email.
I would then suggest using Parse text with regular expressions to retrieve your URLs from the body. When you enable the "Is regular expression" toggle in the Parse text action, you can retrieve the matching string from your text. And when you disable the "First occurrence only" toggle, you can retrieve all matching strings, if multiple matches are found.
These will be stored in a variable called %Matches% and you can loop through it with another For each action, use Go to web page on each current URL, and do whatever you need done to download your documents.
A sample flow would look somewhat like this:
However, in order to provide the exact regular expression to get it, I would need to see a sample body of such an email.
-------------------------------------------------------------------------
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.
