cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Foxzor
Helper III
Helper III

Archive sharepoint items - Methodology, solution

Hello!

 

Do you have any idea, solution for below?

 

I have a sharepoint list as database for my powerapp. I would like to create a flow what is count the items within the SP list and if it reaches the 400 pieces moves these 400 items to an another SP list and delete these 400 pieces items from the original one

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @Foxzor ,

 

In the loop and after the Create Item but before the Delete Item, use the below two actions

 

Get Attachments - from old list item

 

ericcheng_0-1632135970477.png

 

Add attachments - to new list item

ericcheng_1-1632136024177.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

View solution in original post

3 REPLIES 3
eric-cheng
Solution Sage
Solution Sage

Hi @Foxzor ,

 

This is the basic structure of a flow to do what you are after.

 

1) Get Items and specify to order by Created and limit to 400 items

2) For each returned item, you will need to create it again in the new list

3) Delete the returned item that was just recreated

4) Rinse and repeat in the loop

 

ericcheng_1-1632099249145.png

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

Thank you! Forks like a charm! One additional question? How can I move the attachments as well? 

eric-cheng
Solution Sage
Solution Sage

Hi @Foxzor ,

 

In the loop and after the Create Item but before the Delete Item, use the below two actions

 

Get Attachments - from old list item

 

ericcheng_0-1632135970477.png

 

Add attachments - to new list item

ericcheng_1-1632136024177.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,329)