Skip to content

Passing Multiple Users As A String to a Person/Group Lookup Column in a SharePoint 2010 Workflows

by on July 23, 2012


The solution to finding out what format you need to use is to write a value of a multi-user lookup column, with multiple users already in it, to the Workflow History List and return the field as a string when you do.



Workflow History List

The workflow history can be found at an address like the below and is a hidden list – At least, I do not know of a way to navigate there other than typing in the url.



Syntax of multiple Person/Group User Lookup Column as a String


Return Field As

This Dropdown seems to appear only for Person/Group type columns.

  1. As String (Syntax is User ID Number and then User Name – ex: 96;#Emerson Bruce)
  2. Display Name
  3. Email Address
  4. Login Name
  5. User Id Number

Create Task & assign to users

  1. Action > Tasks > custom task processimage
  2. Click on “These Users”
  3. Participants: Select users or group
  4. Make sure Participants are set to “All at once”


Concatenate Multiple Users String As Tasks Are Completed

  1. Click on Task (#) link > change title appropriately
  2. Click on “Change behavior of a single task”image
  3. When a task completes
  4. set TeamString (string) to the correctly formatted and concatenated string value





Advanced Actions with Outcomes

You can wrap the entire process in an outcome If statement!

In the example below, I have two possible outcomes, OptIn and OptOut.



  1. Rich permalink

    Thanks Emerson – that helped me through a tricky SPD workflow issue. Had to populate a multi pick person field through a workflow – used your tips to set some variables based on domain\user then added to the person field as a long concat’d string.
    Cheers for the help!

  2. Jason Lehr permalink

    Can’t seem to get this to work to update an attendee column in a SharePoint 2013 calendar list. Trying to avoid having the end user being able to edit existing attendees which is why I’d like to do a custom action button that starts the workflow where it grabs existing users (tried as a string or displaynames semicolon delimited) and then adds the workflow initiator to it and updates that field.

Trackbacks & Pingbacks

  1. SharePoint: Recopilatorio de enlaces interesantes (VI)! - Blog del CIIN

Leave a Reply

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

You are commenting using your 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


Get every new post delivered to your Inbox.

Join 46 other followers

%d bloggers like this: