Aug 30 2019 01:46 PM
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?
Aug 30 2019 11:58 PM - edited Aug 31 2019 03:14 AM
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
Sep 04 2019 08:06 AM
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.