Move items from one sharepoint list to another

[BFinchy]

Hi, I'm hoping someone out there can assist me please.

I have created 2 sharepoint lists 'Express Pickup Hold Rack' & 'Express Pickup Hold Rack Archive' both lists are identical.

I want to automate a workflow that moves an item to the Archive list when the status in the 'Collected' column changes to YES.

I am not a tech person so simply is what I'm after please.

Thanks for any assistance

[#2]

@BFinchy Do you want to archive list item immediately when the column value changes or on schedule (daily/weekly, etc.)?

Check these solutions:

1. On schedule using Recurrence trigger: Auto archive items in SharePoint using Power Automate 
2. On item modification: Intermediate | Flow of the Week: How to Archive Completed Items in a SharePoint List 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#3]

 Steps to Move Item from one SharePoint site to another.                                                                                                                                                                                                                        

1)select the trigger "When an item is created or modified", and choose the "Express Pickup Hold Rack" list from the SharePoint site.

2)Add a condition to check if the value of the "Collected" column is equal to "YES" by setting a value as true.

3)If yes" branch of the condition, add the action "Create item" and choose the "Express Pickup Hold Rack Archive" list. Map the fields from the original item to the corresponding fields in the archive list.

4)Also to remove the item from the original list after archiving, add the action "Delete item" and choose the "Express Pickup Hold Rack" list.

@BFinchy