Forum Discussion
Sharepoint 365 Moving an item after the status is modified
I have a sharepoint list where users report faults. Once I modify the status ( Column in the list) as resolved, I want it to get archived or be moved to another list. how can I make it happen?
2 Replies
Personally, I would advise against moving archive items to another list as it requires that you keep both lists in perfect sync. Any changes made to the main list must also be made to the archive list or you will lose data. It also seriously complicates your reporting if your data is in separate lists. Even if it's something you think you could handle, what happens to the person who inherits this list after you?
A better option is to create a new view with a filter on your status column so that resolved items are hidden. Call it Active or Open Items.
You can use Microsoft Flow for this scenario. Refer the below thread for more info.
https://powerusers.microsoft.com/t5/Building-Flows/Move-Sharepoint-Item-to-a-second-list/td-p/61408
