Forum Discussion
List Form Formatting - can't get title and hyperlink from Hyperlink column
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] + '^', '^'))"
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
and title
michalkornet hello I have a similar issue - i have different URLs and Alternative text in a Hyperlink Column. In the normal list they work fine, but when I apply JSON in Format Current View the link doesnt work. It opens to about:blank.
What is missing from my code?
Thank you,
Hi LauraDaisy, could you provide the part of your View formatting code related to the URL column? I’ll try to check it promptly.
- Thankyou, this is the code I use on the row formatting.
"elmType": "a",
"attributes": {
"href": "[$Link.url]",
"target": "_blank"
},
"txtContent": "[$Link.desc]"Hi LauraDaisy, I checked again today, and it looks like the column formatting has started working. However, the issue with the view formatting remains the same.
You can try this sample on your environment (in my case I get empty value when I use hyperlink column) https://github.com/pnp/List-Formatting/tree/master/view-samples/menu-link-tiles