'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Preserve Excel Hyperlinks in Power Automate Flows
Question details
Users need to maintain clickable hyperlinks when transferring data between Excel workbooks using Microsoft Power Automate.
- Product
- Microsoft Excel, Power Automate
- Device & OS
- not provided
- Scenario
- A Power Automate flow is configured to transfer rows from a generated Excel file into a database workbook.
- Observed behavior
- Hyperlinks from the source Excel file are converted to plain text instead of remaining as clickable link objects in the destination workbook.
Ensure both your source and destination Excel workbooks are formatted with supported Tables, as Power Automate requires defined Tables to read and write row data accurately.
Use Separate Columns for URL and Display Text
The most reliable workaround is to extract the hyperlink into its raw URL format before processing it in Power Automate.
Power Automate's Excel connector typically receives a hyperlink cell as its display text rather than recognizing the underlying URL object. Splitting the data prevents the link from being lost.
In your source Excel file, set up two separate columns: one named 'Display Text' and another named 'Raw URL'.
Populate the 'Raw URL' column with the actual web address (e.g., https://...) instead of embedding it inside a hyperlink object.
In your flow's 'Add a row into a table' action, map the 'Raw URL' dynamic content directly to a destination column configured to accept URLs.
Reconstruct Links with the HYPERLINK Formula
Use Excel's built-in formula to dynamically rebuild the clickable link in the destination workbook after the text is transferred.
Seek Connector-Specific Help in the Microsoft Community
If connector limitations persist, consult Microsoft's dedicated Power Platform forums for advanced flow configurations.
Experience Hassle-Free Spreadsheets with WPS Office
If you are tired of complex connector issues and data formatting limitations in Microsoft Office, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy a familiar user interface, seamless migration, and native support for all your spreadsheet tasks.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded setup file and follow the simple on-screen instructions.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to edit data and manage formulas seamlessly.
Frequently Asked Questions
Why does Power Automate strip my Excel hyperlinks?
Power Automate's standard Excel connector reads the 'Display Text' of a cell rather than extracting the underlying hyperlink object. Because it only captures the visible text, the URL is lost during the transfer.
Can I use a script to extract hyperlinks in Excel before running the flow?
Yes. You can use Office Scripts or VBA macros in Excel to extract the underlying URLs from embedded hyperlinks and output them into a new column, which Power Automate can then read as plain text URLs.
Does the HYPERLINK function work the same way in WPS Spreadsheet?
Absolutely. WPS Spreadsheet fully supports the standard HYPERLINK function, allowing you to create clickable links from raw URLs with the exact same syntax used in Microsoft Excel.
