Others

Sync SharePoint Hyperlink URLs and Display Text in Power Automate

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs a Power Automate flow to copy both the URL and the descriptive display text from a SharePoint Hyperlink column to another list.

Product: Power Automate
Device & OS: not provided
Scenario: Copying list items with a Hyperlink column from one SharePoint list to another using a Power Automate workflow.
Observed behavior: The flow successfully transfers the hyperlink URL, but fails to copy the associated descriptive display text, leaving the new column incomplete.

Before you start

Verify your current flow configuration and ensure you have edit access to both the source and destination SharePoint lists.

Solution 1Recommended

Consult the Microsoft Power Platform Community

Complex Power Automate flow mappings for dual-field columns (like URL and description) often require advanced JSON configurations best addressed by community experts.

A SharePoint Hyperlink column is a complex field that holds two distinct values: the URL and the Description. Standard 'Create item' or 'Update item' actions in Power Automate often default to mapping only the string value (the URL). To map both fields, you typically need to use an HTTP request or specific expression mapping.

Since this requires highly specific Power Automate configuration based on your unique environment, getting guidance from Microsoft's dedicated community is the most effective approach.

Gather flow details

Take screenshots of your current Power Automate flow configuration, specifically the trigger and the 'Create item' or 'Update item' actions.

Document column settings

Note the exact column internal names and settings for the Hyperlink columns in both the source and destination SharePoint lists.

Visit the community forums

Navigate to the official Microsoft Power Platform Community website and log in with your Microsoft account.

Post your question

Submit a detailed question including your screenshots. Explain that only the URL is mapping successfully and ask for the proper expression or HTTP request to map the display text.

Advanced Approach: If you are familiar with REST APIs, you can bypass the standard connector limitations by using the 'Send an HTTP request to SharePoint' action to patch both the 'Url' and 'Description' properties.

Free Microsoft Office alternative

Looking for a simpler way to manage your office documents?

While Power Automate and SharePoint handle complex data workflows, everyday document creation and spreadsheet management should be straightforward. WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office, letting you focus on your work without complex setups.

1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the setup file and follow the simple on-screen instructions to install the suite.
3. Open existing files: Double-click any existing Microsoft Office document to open it seamlessly in WPS Office without losing any formatting.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (docx, xlsx, pptx).Lightweight installation that runs smoothly on Windows, Mac, Linux, and mobile devices.Familiar, intuitive user interface requires zero learning curve.Built-in advanced PDF editing, conversion, and merging tools at no extra cost.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate only copy the URL in a SharePoint Hyperlink column?

A SharePoint Hyperlink column is a complex object containing two properties: 'Url' and 'Description'. When using basic mapping in standard Power Automate actions, the connector often extracts only the primary string, which is the URL. The Description (display text) must be explicitly referenced using expressions or JSON payloads.

How can I extract the display text from a Hyperlink column using expressions?

You can isolate the display text by using a dynamic expression in Power Automate. If you use a 'Get item' action, the expression typically looks like `item()?['YourColumnName']?['Description']`. This retrieves the text portion of the link.

Can I format a URL as a clickable link with display text using an HTTP request in flow?

Yes. By using the 'Send an HTTP request to SharePoint' action, you can perform a POST or PATCH request. In the body of the request, format the field metadata to include both properties: `{"__metadata": {"type": "SP.FieldUrlValue"}, "Url": "https://example.com", "Description": "Click Here"}`.

Office Quick Solutions