04
May
10

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.

 

image

 

image

Advertisements

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


  1. 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

  2. 3 Tim
    October 5, 2011 at 8:18 am

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

  3. 4 Brian peck
    October 17, 2012 at 11:40 am

    Can this be used with a local variable in the URL string?

  4. 6 grape
    November 19, 2012 at 4:12 pm

    thank you very much for this tip

  5. January 14, 2015 at 6:19 am

    Excellent… Thanks for the post. That space between a comma and title field was really worth mentioning. Well done!!

  6. 8 Khushi
    August 11, 2015 at 10:22 am

    Thank you your post was really helpful to me! Bless you!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Asif Rehmani’s SharePoint Videos

SharePoint-Videos

Click to access a wealth of SharePoint videos

SharePoint Rx

SharePoint Rx Home

Categories

Posts by Date

May 2010
M T W T F S S
« Apr   Jun »
 12
3456789
10111213141516
17181920212223
24252627282930
31  
Support Wikipedia

%d bloggers like this: