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?
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:
- Create a workflow
- Build a string with appropriate URL/String
- Update the item in the list (this means you will have to create another field and hide/remove the calculated field you currently have)
Create a new column, 'Hyperlink or Picture' type, ensure that it is Hyperlink
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
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
Set the variable to the Hyperlink field created.