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

Whats the best way to go about this:

I have a user list that someone enters item information in. Then a user enters an item, we want to have that item automatically created in an identical admin list. Then be able to change some fields in the admin list. These edited fields will then be updated to the user list when changed in the admin list.

share|improve this question
Go Rockets btw! – Eric Alexander May 23 '14 at 20:42
up vote 1 down vote accepted

I would say using workflow to do it but it could get messy if not planned appropriately.

The destination list will need to have a lookup column to the source list to maintain referential integrity or things could get out of sync. When a user creates an item in the source list, it creates an item in the destination list and sets the lookup column to link them together.

Then in the destination list you would have a workflow that rights to the source list, looking up what item to update via the lookup column.

This would require that users on the source list have access to add items to the destination list, unless you plan to add an impersonation step in the workflow.

share|improve this answer
If I have a workflow on both lists that starts when an item is modified, will this cause an infinite loop because the workflows will keep modifying the list? – Bobcat88 May 27 '14 at 17:40
No, the system should not allow that to happen. – Eric Alexander May 27 '14 at 17:51
Okay well I'll will let you know pretyy soon, ha – Bobcat88 May 27 '14 at 17:53
Hmmm kind of strange actaully, I use nintex workflow instead on sharepoint designer. So I make the change on one list and it will do the change then there are 5 more versions added after that but those are making no change. So it seems as if it does loop but then stops. I do need to make some changes to this somehow though because I want proper versioning – Bobcat88 May 27 '14 at 18:07
5 more versions of what? Not sure what you are trying to do exactly, the workflows are only going to affect the related item, a 1 to 1 update of the source and child. Where is this one to many versioning thing happening? – Eric Alexander May 27 '14 at 18:36

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.