Help with URL display names

[Andrew1975]

I have a flow which copies new or updated list items from one list to another list. In the original list there is a URL field. This displays the URL using the Display name, in the list:

However in the clone list, is displays with the just the URL:

Is there an expression I can use so that it shows using the display name, but is still a clickable link like the original list? The current value is: triggerOuputs()?['body/Document_x0020_Link']

Many thanks. 

[Expiscornovus · Accepted solution]

Hi @Andrew1975,

As far as I am aware that is a limitation of the hyperlink column in the create and update item actions of the SharePoint connector.

However, there are a couple of workarounds possible.

First of all you can use an Send an HTTP request to SharePoint to create the item and set the value for the hyperlink column instead.

Below is an example of that.

In my example below my hyperlink column is called TestUrl, you should change that to your column name btw.

{
    "Title":"Test",
    "TestUrl": {
        "Description": "google",
        "Url": "http://www.google.com"
    }
}

@tom_riha has written an nice blogpost about some other alternatives via column formatting or using a rich text field instead:

https://tomriha.com/how-to-update-sharepoint-hyperlink-column-in-power-automate/

Hope this helps a bit?