SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
How to move item to folder automatically when it has been added or edited in a library? The folder is in the same library. The correct folder will be defined by metadata. This should happen automatically when the item has been added or edited. The listitem Id should be preserved. No server-side code should be deployed.
Can this be done using workflows (SP2010/SP2013)? If not then what would be the other options?
Workflows cannot "move" an item, they can only copy it (which would preserve metadata but not listitem IDs). The built-in IDs cannot be changed or set manually. Your best bet is to create your own ID system using a workflow or event receiver to assign unique IDs to new items, and make a simple program to go through and assign IDs to all the existing items if necessary. Then you can use the "Copy list item" function in a workflow to create a duplicate in the new location, using conditional statements to read your metadata and determine where to place the new item, and you will be able to preserve the IDs you created. Workflows have the advantage of being able to be triggered by new items and/or changes to existing items.
Note that only 2010 workflows have the "Copy list item" action. In 2013 you have to use the "Create list item" action and manually assign all the fields. In either case you will have to use the "Delete item" action to remove the original item once you copy it to its destination.
