Setting the URL and Hyperlink Description Simultaneously on a URL Field in a SharePoint Designer Workflow

May

Setting the URL and Hyperlink Description Simultaneously on a URL Field in a SharePoint Designer Workflow

If you need to update a URL field in a links list (or any other list) from SharePoint Designer, you need to know this little trick. Create a string that contains the URL and description like this:

URL, Description

and then update the field with this string. Notice there is a comma AND A SPACE after the URL. There are no brackets, curly braces or octothorpes (# signs) involved in the string.

Using the string builder, you can see the "input" and the "output" of the workflow.

Like this:

Be the first to like this post.

3 Responses to “Setting the URL and Hyperlink Description Simultaneously on a URL Field in a SharePoint Designer Workflow”

Feed for this Entry Trackback Address

1 Roel de Jongh
February 1, 2011 at 8:55 am

I’m using the same solution with a workflow. The only problem i am getting is the following :

- If the value of the webaddress has a comma than the description field is updated in a wrong way.

URL : http://server/Lists/Clients/EditForm.aspx?Company=Company, Ltd
Desciption : Ltd, View

The right description should be : View.

But the comma in the URL is used.

How can i find a way to prevent the description from changing into the wrong value ?

Regards,

RdJ

Reply
- 2 Russell Wright
  February 1, 2011 at 9:37 am
  
  URL encode the comma with %2C?
  
  ?Company=Company%2C%20Ltd
  
  Worth a try.
  
  Reply
3 Tim
October 5, 2011 at 8:18 am

Thanks for this simple but helpful post. Solved my problem.

Reply