Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have two list in sharepoint 2010. In List A i have Assigned to field column(people or user group). In List B i have two fields Name and Email id column. I need the email id values of List B should be assigned to (List A assigned field column) when adding new item in the List A.

How can i achieve this.

share|improve this question
    
Could you clarify what do you want to do? Please describe structure of lists column by column and how list are connected. It is quite difficult to understand what you have and what you want from you description. –  Anton Khritonenkov Apr 10 at 4:19
add comment

1 Answer

An Assigned To field points to people and groups, not to another list. I see 3 ways to address your issue:

  1. Instead of list B, create a SharePoint group, and have your Assigned To field point to that group.
  2. Instead of an Assigned To field, use a lookup field that points to list B
  3. A combination of both. For example use a lookup field that points to list B, then have a workflow copy the lookup value to the Assigned To field.

The choice will depend on your specific needs and constraints. The first solution is the easiest if it works in your case.

For the third option, use the e-mail address as key: copy the e-mail address of list B to the Assigned To field, SharePoint will find the related people.

share|improve this answer
    
Thanks for your reply.I am using the combination of both. I have lookup field that points to list B, then how to have a workflow copy the look up value to the Assigned To field.Please suggest how to do the workflow or any example. –  user876869 Jul 25 '12 at 6:22
    
@user876869 I have updated the post, let me know if you need more details. –  Christophe Jul 25 '12 at 15:28
    
I didnot understand from your update... –  user876869 Jul 25 '12 at 15:57
    
Have you already used SharePoint Designer workflows, and in particular the action to update a field in the current item? –  Christophe Jul 25 '12 at 16:13
    
Thanks for your information. But my requirement is achieve through the Custom Action of Work Flow. –  user876869 Jul 25 '12 at 17:21
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.