Forum Discussion
How to format link column?
hemenzel What is the column type in SharePoint used to store this information? If it is a multiple lines of text column storing this complete JSON array, I don't think you will be able to make if clickable using JSON formatting.
However, you can use expression like below in Power automate flow to extract only link from the JSON:
@{first(json(variables('strJSON')))?['link']}Example:
Output:
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
hemenzel What is the column type in SharePoint used to store this information? If it is a multiple lines of text column storing this complete JSON array, I don't think you will be able to make if clickable using JSON formatting.
However, you can use expression like below in Power automate flow to extract only link from the JSON:
@{first(json(variables('strJSON')))?['link']}
Example:
Output:
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
ganeshsanap Thanks - this gives me something to work with! Yes, the column setting is multiple lines. Can you recommend how to pull the link info if the source data (Agenda) is like so?
hemenzel You can use the same expression like below if you are having hyperlink property named link inside nested Agenda column value:
@{first(json(variables('strJSON')))?['link']}Use this inside compose action after initialize variable action.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
ganeshsanap, Ah, okay....I set it up like this, but am now getting an "invalid template" error....
first(json(variables('strJSON')))?[triggerOutputs()?['body/Agenda']]I appreciate your help!!
