SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Basically i want to add items to 1 list based on columns from another list. so for example say i have 2 list, List 1 and List 2. List 1 has 5 colunms; Name, Age, id , Location, Manager. List 2 contains 3 colums; Name, Location, Manager.

What i want to do is when an item is added to list 1 i want to automatically add a new item to list 2. List 2 colunms should be autopopulated by the colunm values from list 1.

Anyone any ideas how i could acheive this i have tried using lookup values and i also tried using a workflow but cant seem to get it working properly. i am new to sharepoint.

share|improve this question
I am essentially trying to do the same thing, is there anyway to do it without sharepoint designer – user38853 Jan 21 '15 at 2:01
up vote 4 down vote accepted

You definitly can do this with workflows.

Just create a list-workflow on List1 which creates a new Item on List2 with the given item values and set the workflow to "Start workflow automatically when an item is created".

All you need for this task is the SharePoint Designer.

If you do so, also consider the occurence of changes in List1 or List2.

share|improve this answer
Cheers got it working using workflows thanks – derek Oct 26 '12 at 12:59
For some reason I didn't see this the first time I looked to do this (being blind ftw?). Thansk! – enderland Sep 5 '13 at 14:34

Your Answer


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.