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.


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.

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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