Sharepoint - Add Hyperlink item to List

  • 759 Views
  • Last Post 31 May 2024
pauldtosco posted this 08 May 2024

Hi,

I'm trying to use the SharePoint Connector to add a hyperlink to a List item. However, I can only seem to upload correctly if the List item is set to Text - if I set it to hyperlink not only does the hyperlink not populate, but none of the remaining metadata uploads either.

Is there a way to get a hyperlink (URL) into SharePoint AS a hyperlink, or am I limited to sending plaintext metadata only?

Thanks for your time.

Order By: Standard | Newest | Votes
luca.scarpati posted this 31 May 2024

Hi Paul,

 

great and thanks for the info, for "advanced" Sharepoint users only cool.

Have a nice weekend!

Luca

 

pauldtosco posted this 08 May 2024

 Call off the hounds, I was able to format the uploaded url using SharePoint's json formatting.

I went the column containing the plain text url, clicked Column > Column Settings > Format this column and added the following json (in the advanced mode link):

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "a", "attributes": { "href": "@currentField", "target": "_blank" }, "txtContent": "Link" }

 

This makes the text a clickable hyperlink that opens in a new browser tab. It hides the full URL behind the word "Link". If you want the url text to visible instead, change the value of txtContent to @currentField.

 

Leaving this here just in case someone else finds it useful.

Close