How to copy a hyperlink from an email and store as a new row in Excel using power automate

Question

Hi community. From emails I receive, there is a hyperlink. I need to copy the hyperlink into an Excel spreadsheet. I have the flow set up to create a new row and fill in the rest of the required information. I need the hyperlink saved as the task number on the email, not as the url. 20230822_153006.jpg I have tried the expression concat('a< href="', variables('URL'), '">', variables('Task number'), '</a>') Please help.

Answer 1

Hi @J G,

Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You can ask the experts in the dedicated Power Automate forum over here:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Appreciate your patience and understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.