SharePoint Document Issues

How to Preserve Full SharePoint URLs in Power Automate Emails

Maira Mehtab Sep 22, 2026 869 views

Question details

Users need to ensure that URLs extracted from SharePoint rich-text fields and sent via Power Automate emails retain their full HTTP or HTTPS paths instead of becoming relative links.

Product: Power Automate and SharePoint
Device & OS: not provided
Scenario: Extracting hyperlink data from SharePoint rich-text fields to include in automated email notifications using Power Automate.
Observed behavior: Power Automate pulls relative links from SharePoint rich-text fields instead of complete URLs, resulting in broken links in the generated emails.

Before you start

Ensure you have edit permissions for the Power Automate flow and confirm the base URL of your SharePoint site where the rich-text column is hosted.

Solution 1Recommended

Prepend the SharePoint Site Address to Relative Links

The most straightforward solution to fix relative links is to manually concatenate the base SharePoint URL with the dynamic content in your flow.

SharePoint often stores links internally as relative paths (e.g., '/sites/MySite/Lists/MyList'). By manually appending your site's root URL in front of this relative path within Power Automate, you can successfully reconstruct a fully functional absolute link.

Open your Power Automate Flow

Navigate to the Power Automate portal, find your specific flow, and click Edit.

Switch to HTML View

Locate the email action (such as 'Send an email (V2)') and click the code icon to switch the email body field to HTML view.

Concatenate the URL

Find the `<a href="...">` tag where your dynamic content is placed. Insert your base SharePoint site URL (e.g., `https://yourdomain.sharepoint.com`) directly immediately before the dynamic content token.

Testing Required: Send a test email to yourself to verify that the reconstructed link resolves properly when clicked.

Solution 2

Use the SharePoint HTTP Request Action

For more complex scenarios where prepending text is difficult due to multiple links or complex HTML, you can query SharePoint directly to retrieve the complete URL structure.

Solution 3

Enable Enhanced Rich Text for the SharePoint Column

Adjusting the column settings natively in SharePoint can occasionally force better formatting handling before the data is even sent to Power Automate.

Free Microsoft Office alternative

Use WPS Office as a Free and Lightweight Alternative

While resolving Power Automate and SharePoint integration problems requires Microsoft ecosystem configuration, you don't need an expensive subscription for your primary desktop document tasks. WPS Office offers a free, lightweight, and robust solution for creating, editing, and managing your office files without the overhead.

1. Download the Installer: Visit the official WPS Office website and click on the Free Download button.
2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup.
3. Open and Edit Files: Launch WPS Office and instantly open your existing Office documents with full compatibility.

Highly compatible with Microsoft Word, Excel, and PowerPoint file formats.Lightweight installation ensures fast document loading and lower system requirements.Built-in PDF editing tools for versatile local document management.Familiar user interface guaranteeing a seamless migration from other major office suites.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate change my SharePoint URLs to relative links?

Power Automate doesn't actually change them; SharePoint inherently stores internal hyperlinks as relative paths to save database space and maintain link integrity in case the site URL ever changes. Power Automate simply retrieves exactly what is stored.

Does setting the Power Automate email action to HTML fix the link issue automatically?

No. While setting the email action to HTML view is required for standard anchor tags (`<a href>`) to render as clickable links, it will not automatically convert relative SharePoint links into absolute links unless you prepend the base URL.

Can I use standard rich text instead of enhanced rich text in SharePoint?

Yes, standard rich text is available, but enhanced rich text supports full hyperlinks, tables, and pictures natively. Switching to enhanced rich text often improves how HTML payload is passed into integration tools like Power Automate.

Document & File Issues