
Hi @Cooper, Sarah,
Good day! Thank you for reaching out to Microsoft Q&A forum and sharing your experience.
I understand you're using Microsoft Lists in SharePoint to manage daily tasks and would like to move completed items those marked as “Done” to a separate archive list for record keeping and to keep your main list clean and focused.
Based on your description, you've already made to duplicate the list structure and explore Power Automate. Since Power Automate isn’t available in your environment, here's a few alternative steps that may suit your situation.
- You can manual copy using Grid View
This method allows you to manually move items between lists without automation:
- Open your source list (the one with active tasks).
- Click on “Edit in grid view” at the top right of the list.
- Locate the row you want to move and manually copy each field’s value (you can use your mouse or keyboard shortcuts to copy individual cells).
- Open your Archive list and also switch to grid view.
- Paste the values into a new row in the archive list.
- Once the item is successfully added to the archive list, you can delete it from the original list.
Therefore, this method works best for a small number of items and doesn’t require any special permissions or tools.
- You can try to request Admin Access to Power Automate (if possible)
If your organization allows, enabling Power Automate would make this process seamless:
- You can create a flow that automatically moves items to the archive list when their status is set to “Done.”
- The flow can also delete the original item after copying it.
If this option becomes available, I’d be happy to help you set it up step by step.
- If you’ve already tried the steps above and the issue still persists, I recommend posting your question in the Microsoft Power Automate Community: Microsoft Power Platform Community Forum Thread
This forum is dedicated to Power Automate and includes experienced users and Microsoft partners who regularly share solutions and best practices. It’s the best place to receive deeper technical support and tailored guidance for your scenario.
We sincerely apologize for redirecting you, but since our support category focuses on Microsoft 365 products, we have limited resources for Power Automate. Posting in the Power Automate Community will help ensure you get the most accurate and timely assistance.
For more information that you can concern:
- Ensure both lists have matching columns and data types to avoid issues during manual entry.
- You’ll need edit permissions on both lists to perform these actions.
- Unfortunately, Microsoft Lists does not currently support copying entire rows between lists using CTRL+C/CTRL+V.
If you’ve gone through these steps and the issue continues, I’d be happy to help you further. You can reply with more details or let me know which step didn’t work for your situation.
Thank you again for your patience and for choosing Microsoft Q&A forum. Please let me know if there’s anything else I can assist you with. I’m here to support you every step of the way.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.