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?
1 Answer
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)
Updated
Workaround:
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.
-
Thank you for the speedy response! Much appreciated. To clarify my post from above, this IS a workflow, designed in SPD, not a calculated field, so that shouldn't be an issue.Srasch– Srasch2017-07-17 22:01:17 +00:00Commented Jul 17, 2017 at 22:01
-
Okay please update the question with the screenshot of the workflow so we can understand more.SharePointer– SharePointer2017-07-18 07:29:22 +00:00Commented Jul 18, 2017 at 7:29
-
this is updated with more information about the workflow.Srasch– Srasch2017-07-18 15:39:36 +00:00Commented Jul 18, 2017 at 15:39
-
It looks like MSFT stopped supporting this feature, even if it comes from a workflow :( sharepoint.stackexchange.com/questions/218102/…Srasch– Srasch2017-07-18 21:26:13 +00:00Commented Jul 18, 2017 at 21:26
-
1yes! this seemed to work. Very creative :) Thank you!Srasch– Srasch2017-07-21 18:14:48 +00:00Commented Jul 21, 2017 at 18:14
