How to format link column?

[hemenzel]

I'm trying to create a flow that posts an Adaptive Card in Teams based on a new submission to a SharePoint list. 

When a link is added to the related SharePoint list column (via Microsoft Forms), it appears like this: 

How can I get a flow to grab just the link information in order to include it in the adaptive card? Or, better yet, how do I format the Column to make this a clickable link?

[#2 · Accepted solution]

@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

[#3]

@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?

[#4]

@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

[#5]

@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!!

[#6]

@ganeshsanap, never mind, I got it to work thanks to your suggestions. Thank you 100000!!