cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andrew1975
New Member

Help with URL display names

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:

 

image 32.png

 

 

 

 

 

 

 

 

 

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

 

image 33.png

 

 

 

 

 

 

 

 

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']

 

image 34.png

 

 

 

Many thanks. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

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"
    }
}

 

hyperlinkcreateitem.png

 

@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?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

1 REPLY 1
Expiscornovus
Super User
Super User

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"
    }
}

 

hyperlinkcreateitem.png

 

@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?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,616)