Forum Discussion
specoop
Aug 12, 2022Copper Contributor
SharePoint List: make URL in Column Description a hyperlink
Hello all, For my Sharepoint list, I need to make hyperlinks in the description. NOTE: This works fine in Classic mode, but in Modern, the URLs no longer hyperlinks when in the New or Edit view. ...
specoop
Sep 09, 2022Copper Contributor
Thanks ganeshsanap!
So footer could work well, as long as we can add some if statements. With our situation, we've got about 20 different date columns that used to have hyperlinks in the description.
And only the revent ones show up based upon other selections in the list. See below for example.
=if([$Column1] == 'Yes' && [$Column2] == 'Yes', 'true', if([$Column1] == 'Yes' && [$Column3] == 'Yes', 'true', 'false')).
So we have that conditional formatting for each of the 20 or so date columns.
Any way we could dynamically only have certain columns appear in the footer (that are hyperlinks)? I know it's much harder here compared to PowerApps, but this is what we've got access to.
Thanks again,
Spencer
So footer could work well, as long as we can add some if statements. With our situation, we've got about 20 different date columns that used to have hyperlinks in the description.
And only the revent ones show up based upon other selections in the list. See below for example.
=if([$Column1] == 'Yes' && [$Column2] == 'Yes', 'true', if([$Column1] == 'Yes' && [$Column3] == 'Yes', 'true', 'false')).
So we have that conditional formatting for each of the 20 or so date columns.
Any way we could dynamically only have certain columns appear in the footer (that are hyperlinks)? I know it's much harder here compared to PowerApps, but this is what we've got access to.
Thanks again,
Spencer
ganeshsanap
Sep 12, 2022MVP
specoop Yes, you can create multiple hyperlinks in header/footer and show/hide them based on conditions. Here's an example you can refer & build JSON for your requirements accordingly:
{
"elmType": "div",
"children": [
{
"elmType": "a",
"txtContent": "Link 1",
"style": {
"display": "=if([$Column1] == 'Yes' && ([$Column2] == 'Yes' || [$Column3] == 'Yes'), 'block', 'none')"
},
"attributes": {
"href": "https://www.google.com/",
"target": "_blank"
}
},
{
"elmType": "a",
"txtContent": "Link 2",
"style": {
"display": "=if([$Column5] == 'True value', 'block', 'none')"
},
"attributes": {
"href": "https://www.google.com/",
"target": "_blank"
}
},
{
"elmType": "a",
"txtContent": "Link 3",
"style": {
"display": "=if([$Column6] == '', 'block', 'none')"
},
"attributes": {
"href": "https://www.google.com/",
"target": "_blank"
}
}
]
}
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.