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