Forum Discussion
Solved
List Form Formatting - can't get title and hyperlink from Hyperlink column
I have a Hyperlink column and trying to display it within the footer of the List Form using JSON formatting. However, I can't seem to split the Title and URL of the Hyperlink value. If I just try...
Hi grant_jenkins, You are right; the Hyperlink column value behaves differently in column formatting compared to form formatting.
Fortunately, you can use the following function to retrieve Hyperlink column information in form (header or footer) formatting:
- Url
"txtContent": "=substring('[$FieldName]',0,indexOf('[$FieldName]', ','))"and title
"txtContent": "=substring('[$FieldName]',indexOf('[$LinkTest]', ',')+2,indexOf([$FieldName] + '^', '^'))"
Thankyou, this is the code I use on the row formatting.
"elmType": "a",
"attributes": {
"href": "[$Link.url]",
"target": "_blank"
},
"txtContent": "[$Link.desc]"
"elmType": "a",
"attributes": {
"href": "[$Link.url]",
"target": "_blank"
},
"txtContent": "[$Link.desc]"
Hi LauraDaisy, it looks like there is an issue with the Hiperlink column. I have also tried one of the sample provided on PnP Samples page, and unfortuantely I cannot see the description of the link (without any customization it works)
https://github.com/pnp/List-Formatting/tree/master/column-samples/hyperlink-display-url
when I use "txtContent": "[$Link]" is has simply a link. Let me ask on samples repository, maybe someone has the same issue.