I wonder if you can help me here.
How would I preserve the Modified date when a list item is changed?
I’m trying to create an archiving solution* using a workflow to copy older items to a second list, as follows:
I have two lists, each with identical columns. A workflow, running on the first list, sets LastModified column to the Modified date.
Archive Date is a calculated column which adds 30 days to the created date (=created+30).
The workflow has a Pause command so when the Archive Date is reached the item is copied to the second list archiving items older than 30 days.
The workflow then deletes the original item on the main list.
As an aside, when the item is copied, the original created date won’t be retained on the second list – to preserve this, the created date is saved to an ‘original creation date’ field via the workflow.
[*The archiving could be done through a list retention policy – however I can’t get this to work, either by moving items to the recycle bin or by triggering a workflow from the retention policy to copy items to a second list]
The workflow is set to run on created and changed.
Do you have any suggestions how to preserve the Modified date?