How to set hyperlink field with SharePoint Designer WorkFlow

Question

I'd like to know how to set with a WF sharepoint 2010 and hyperlink column. When i set a value, it's only for url and i can't set description.

Do you have a sample or tutorial to do this?

Answer 1

To do this you need to use the build a dynamic string action. In it, you construct your url, description value information. Example, http://google.com, Google. The comma and space are important.

Then you use this variable in your update action to set the value. Upon completion of the workflow, you should see it set properly.

Answer 2

Great idea, but I had to do a bit more trickery.

Background, I’m writing a custom workflow in SPD against a SP list located in SharePoint Online as part of MS' Office 365 solution.

First, create a column in your list that is type Hyperlink. Select URL as the sub-type. Second, in SPD, do these steps:

1. Add a new action for Set Field
2. In that action, click on the word field and select any text column. Title is a good one. It doesn't matter because we'll change the selected column in a bit.
3. Click the 3 dots to open the dynamic string builder.
4. Add the URL proper as the first part, e.g. https://your_SharePoint_domain/... Note: this string can include any suffix like /editform.aspx?ID=1&DefaultView=Admin. It can also be a workflow variable with all of that in it. Just make sure it is a valid URL. Add a comma and space and your display text. As said from the answer above, the space is important. If you used a workflow variable, the string might look like Variable: [%yourWorkflowVar %], Text to Display. If just a string, it might look like www.google.com, Google.
5. Click OK to close the string builder dialog.
6. IMPORTANT: click the column name immediately to the right of Set and scroll through the drop box to find your URL column. You will notice that the string you built above remains intact.
7. If you ever need to edit your string, repeat the above. Reason: SPD forces the Edit Hyperlink dialog which will not have a dynamic string build function.

That's it.