Hyperlink in SharePoint Document Library

Question

I have a document library that has additional columns filled with various types of data. One of these columns is set using a workflow in SPD as a hyperlink. For over a year this column did in fact appear as a hyperlink, as it should have. However, last week the hyperlink stopped appearing and in its place appeared HTML. Does anyone else have this same issue? Do you know of a way to fix it?

Answer 1

It seems that you are on the SharePoint online and calculated field was used to create the hyperlink which is not supported anymore by Microsoft. Have a look at this.

A possible workaround would be to:

1. Create a workflow
2. Build a string with appropriate URL/String
3. Update the item in the list (this means you will have to create another field and hide/remove the calculated field you currently have)

Updated

Workaround:

1. Create a new column, 'Hyperlink or Picture' type, ensure that it is Hyperlink

2. Create a workflow variable (which you already have Link), just remove all the HTML it should be something like: https://mytenant.sharepoint.com/sites/Shared%20Documents/Forms/EditFile.aspx?ID=[%Current Item:ID%]&Source=Pending%20Approval.aspx

3. Immediately after the url put a , (comma) and a space followed the text you want to display. This should be like: https://mytenant.sharepoint.com/sites/Shared%20Documents/Forms/EditFile.aspx?ID=[%Current Item:ID%]&Source=Pending%20Approval.aspx, Click Here to Approve

4. Set the variable to the Hyperlink field created.