archive one list item (SP1) to another list (SP2) based on "every 3.5 months. (sharepoint lists already created)

Like (0) Share

Report

Posted on 14 Jul 2022 20:33:08 by vez

Hello!

I've got a sharepoint list that is reaching its capacity. There are items that are from years ago that I need to transfer to my archive sharepoint list. How can I transfer them, requests from 2020- OCT 2021, and how do i recur this flow every 3.5 months? After archiving the very old items, I would like the flow to archive the requests that are the oldest (3 month intervals). Hopefully I am making some sense here. I attempted to use previous conversations but nothing truly described my requirements. Thanks!

All responses (1)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on 15 Jul 2022 at 05:15:35

Like (0)

Report

Re: archive one list item (SP1) to another list (SP2) based on "every 3.5 months. (sharepoint lists already created)

@vez You can archive your SP list item using Scheduled flow.

For first part Any manual flow you can design, you need to use get items action with filter query. In your case it should be Date le 2021-10-31 this will give you all items before Oct 2021. And then use create items for archive list.

For second part you want to trigger flow every 3 months to backup your old entries. You need to design schedule flow which will trigger every month on same date like 1st of each month then it will compare dates with your backup periods like 01 April then 1st July then 1st oct then 1st Jan. once condition is satisfied, use get items with filter query which will return 90 days data. Use create item to archive this in your another list.

Do not forget to delete items from original list after create item action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in