web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : npOkqZtp9CaSWQVjh9UcE2
Power Automate - Building Flows
Unanswered

Flow to move SharePoint list items to an archive list.

Like (0) ShareShare
ReportReport
Posted on 16 Feb 2021 11:29:36 by 28

Good morning all,

 

I've searched the forum but couldn't seem to find a solution, apologies if this has been covered before. This is the first flow I've created so apologies if my terminology is incorrect.

 

I have a desk booking app in PowerApps which populates a SharePoint list called Desk Reservations.

 

I have copied this list using ShareGate to create an exact copy called Desk Reservations Archive without any content.

 

The idea is to create a flow that runs at 3am every morning to move all items from the Desk Reservations list to the Desk Reservations Archive list that have a date & time of yesterday or earlier in the CheckOutFrom column.

It appears there is no OOTB action to move a SharePoint list item (there must be a reason for this as you can move a folder) so I've created the following flow:

Flow1.png

Flow4.png

The flow looks like it works and copies the item into the archive list but unfortunately I have the following issues:

 

  • The original list item doesn't get deleted.
  • The Created By & Modified By fields are populated by my account but I need these to be populated by the original list item data.
  • There is another column ReservedBy which is a person or Group column but I can't seem to select this in the create item action nor can I see anywhere to add the column to map it.
 

Flow3.png

 

Any help or pointers I would be most appreciative as to what I'm doing wrong.

Thanks in advance.

  • PADave Profile Picture
    28 on 12 Mar 2021 at 09:28:21
    Re: Flow to move SharePoint list items to an archive list.

    @Mira_Ghaly 

     

    Thank you for your help with this.

     

    I persevered and found this blog post Update the Created By (AuthorID) Field of a ShareP... - Power Platform Community (microsoft.com) and have now been able to update the Created BY & Modified By fields.

  • Mira Ghaly Profile Picture
    11,409 Moderator on 17 Feb 2021 at 09:11:41
    Re: Flow to move SharePoint list items to an archive list.

    @PADave 

    1. Created by / Modified By currently does not appear on the create item , so you need to create 2 new fields of type Person for example: OriginCreatedBy and OriginModifiedBy and then you will have to set them the same way you did with the reserved by

    2. For the delete it looks like the step is correct, i have made a test on my side and it is working..are you sure you can delete manually? 

     

  • PADave Profile Picture
    28 on 16 Feb 2021 at 13:19:13
    Re: Flow to move SharePoint list items to an archive list.

    @Mira_Ghaly 

     

    That solved the ReservedBy issue, thank you very much.

     

    Do you know how I can copy the Created, Created By, Modified & Modified By Colum information as well as there is no option to map these?  A requirement of this flow is for the information to stay intact in the archived list.

     

    Re the deleted part of the flow, it completes successfully but the items remain in the old list.  Does it look like I've gone down the wrong track for the deletion part of the flow?

     

    Flow4.png

  • Mira Ghaly Profile Picture
    11,409 Moderator on 16 Feb 2021 at 12:00:14
    Re: Flow to move SharePoint list items to an archive list.

    @PADave 

    Is the Reserved by Person column single or multiple selecting?

    If single selection an easy solution is to add the Create Item Step and fill it with the Reserved by Claims and this will automatically insert the apply to each loop.

    Regarding the delete have you checked the flow history to check if it is failing?

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2