How to Add Dynamic Hyperlinks to Power Automate Emails from Excel
Question details
The user needs to add unique, clickable dynamic hyperlinks for each recipient in Power Automate emails using row data retrieved from an Excel spreadsheet.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating an automated workflow to send personalized emails where each email contains a different clickable link based on Excel data.
- Observed behavior
- Requires correctly configured HTML email formatting within the Power Automate flow to dynamically insert the URL into the anchor tag for each recipient.
Ensure your Excel spreadsheet is formatted as a Table and saved in a cloud location like OneDrive or SharePoint so Power Automate can properly access the row data.
Configure HTML Hyperlinks in Power Automate Email Action
Use HTML anchor tags within the Power Automate 'Send an email' action to create clickable text that dynamically pulls URLs from your Excel table.
Power Automate sends plain text by default in some configurations. To make a link clickable with custom display text, you must use the HTML code view in the email body editor and insert dynamic content within an HTML anchor tag.
Open your Excel file, ensure the data contains a specific column for the URLs, and format the data range as a Table (Insert > Table). Save the file to OneDrive or SharePoint.
In your Power Automate flow, add the 'List rows present in a table' action, select your cloud location, document library, file, and the specific table name.
Add the 'Send an email (V2)' action to your flow. In the email 'Body' field, click the code view icon (</>) to switch the editor to HTML mode.
Type <a href=" into the body. From the Dynamic content pane, select the Excel column containing your URLs. Close the quote, add a closing bracket >, type your desired clickable text (e.g., 'Click Here'), and finish with </a>.
Manage Your Automation Data Seamlessly with WPS Office
While Power Automate handles your email workflow, you need a reliable, lightweight spreadsheet tool to manage the source data. WPS Office is a free, powerful alternative to Microsoft Office that flawlessly handles all your spreadsheet files, ensuring your data is perfectly structured for automation.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open the .xlsx file you intend to use for your Power Automate flow.
- 3. Format and Save: Format your data as a table, save it directly to your connected cloud drive, and seamlessly link it to your automation flow.
Frequently Asked Questions
Why are my Power Automate links showing as plain text instead of clickable links?
This usually happens if the email body editor is not set to HTML mode. Ensure you click the code view (</>) icon in the 'Send an email' action before entering your <a href="..."> HTML tags.
Can I use WPS Office spreadsheets with Power Automate?
Yes. Power Automate reads standard Excel formats. As long as you save your WPS Spreadsheet in the .xlsx format and store it in a supported cloud service like OneDrive or SharePoint, Power Automate can retrieve the row data.
How do I ensure Power Automate reads my spreadsheet URLs correctly?
Power Automate requires your data to be formatted as a Table. Select your data range in your spreadsheet software and use the 'Format as Table' option. Ensure your URL column contains full, valid web addresses (including https://) so the generated HTML links function properly.
