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 Michal,
Thanks for your confirmation. I've already set them up using the configuration you mentioned above. Hoping Microsoft will fix some of these issues so things work as expected across lists, forms, etc.
