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?

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?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,369)