SharePoint - The link should be behind a text

Question

SharePoint - The link should be behind a text

Martin, Heidi (SE GP T SP PS) 571

Good morning!

Is it possible to insert a link behind text in a text column in SharePoint?

Thank you! User's image

0 comments

Answer accepted by question author

2 additional answers

Your answer

Answer 1

Jones, Christopher 105

I don't think there's a way to get exactly what you want, but I think you can add a hyperlink column to your list to display the text as part of the link.

Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-12-08T07:34:56.3866667+00:00

@Jones, Christopher
Ok - Thank you!
But is there a way to display a link as text and then also see it as text in Viva Engage?

Answer 2

Martin, Heidi (SE GP T SP PS) 571

@Ling Zhou_MSFT

That's great! However, in my case, the text and link keep changing. How can this be modified? I would like to post this content to Viva Engage via a workflow, but when I try, it doesn't include the column I need. What could be the reason for this?

The goal is to post content from a SharePoint list to Viva Engage via a workflow. And the desire is to be able to embed links within text. It looks more attractive than a fully written out link.

Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff

2023-12-08T08:59:02.15+00:00

Hi @Martin, Heidi (SE GP T SP PS),

If your texts or links are dynamic, then you need to create two columns to save the dynamic text or link. Then modify the txtContent and href:

"txtContent": "=[$TextFieldName]"

"href": "=[$LinkFieldName]"

In fact, JSON is not quite capable of applying dynamic content, it can only modify the display style of the item.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-12-08T09:33:51.97+00:00

Thank you so much!!!
Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff

2023-12-11T01:22:57.44+00:00

Hi @Martin, Heidi (SE GP T SP PS),

Thank you for your reply.

Does the answer in my comment address your question? We would appreciate it if you would like to share a recent update on your problem.

Please feel free to reach us if you have any remaining questions or concerns for this issue.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-12-11T05:16:50.95+00:00

@Ling Zhou_MSFT

Good morning,

works well. Unfortunately, I can't get the content to Viva Engage this way. Do you know why? Thank you!
Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff

2023-12-11T06:02:17.3866667+00:00

Hi @Martin, Heidi (SE GP T SP PS),

First of all, I would suggest you to make sure that the link is fine.

Secondly, we are not quite sure how you are posting the content to Viva Engage via Power Automate flow, if convenient please share your flow with us and send us the details of the error message that you are unable to access the Viva Engage content. Please be careful not to disclose your personal information.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-12-11T06:56:20.56+00:00

@Ling Zhou_MSFT

This is my flow:
Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff

2023-12-11T07:11:05.85+00:00

Hi @Martin, Heidi (SE GP T SP PS),

I apologize for some mistakes in my previous answer. The function of JSON formatting is to modify the display style of the items in the list, just the display style, the text content in our JSON will not be saved as a real value in the list. That's why you can't get the contents of that column value in Power Automate. So, I suggest you can give content to the columns in Power Automate flow first and then use it.
Ling Zhou_MSFT 23,690 Reputation points Microsoft External Staff

2023-12-14T08:43:27.0533333+00:00

Hi @Martin, Heidi (SE GP T SP PS),

I am kindly following up to see if you have any remaining questions or concerns for this issue. Please feel free to reach us if any questions or concerns you may have.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 3

Hi @Martin, Heidi (SE GP T SP PS),

Thank you for posting in this community.

Please try use this JSON to format your column.

1.Column settings >Format this column >Advanced mode.

2.Please replace your href.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "span",
      "txtContent": "We have add a"
    },
    {
      "elmType": "span",
      "children": [
        {
          "elmType": "a",
          "txtContent": "vedio",
          "style": {
            "margin-left": "2px",
            "margin-right": "2px"
          },
          "attributes": {
            "target": "_blank",
            "href": "https://XXXXXXXX"
          }
        }
      ]
    },
    {
      "elmType": "span",
      "txtContent": "showcasing our portfolio"
    }
  ]
}

3.Here is my test result. Hyperlinks will open in a new window.

User's image

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

SharePoint - The link should be behind a text

2 additional answers

Your answer