Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Setup a flow to archive old items in a SharePoint list when the list reaches 3000 items

(0) ShareShare
ReportReport
Posted on by 516

I'm looking for suggestions and or ideas on how to handle this current issue:

We seem to run into Power Apps issues when the list has over 2000 to 3000 items. I was wondering is there a way to automate an archiving process based on age of the list item or better yet the when the list hits a certain row counts?


 

 

  • SPS-DEV-22 Profile Picture
    SPS-DEV-22 516 on at
    Re: Setup a flow to archive old items in a SharePoint list when the list reaches 3000 items

    I just found out there is a common column of data that could be used instead of row count... will attempt the archive based on that column.

     

    and yes, I do need to consider the access to the Archived items if they need to look up information at a later date.

    thanks though for the comments.

  • FLMike Profile Picture
    FLMike 31,444 on at
    Re: Setup a flow to archive old items in a SharePoint list when the list reaches 3000 items

    hi @SPS-DEV-22 

     

    It would depend. 1 I would be curious what the issue is as 2000-3000 is super small unless you have a super wide list and lots of heavy columns.

     

    But there is no OOB archive process. And Archival itself is a broader topic. Like will you need to reload them ever, or do you need them for analytics, or for searches (indirect or direct) etc.

     

    The easiest way is to either create a daily or time based flow that runs and counts the rows and then either exports them to a blob or to another matching list. This way you could run your daily or weekly or whatever recurring flow to search by created and or modified and say hey if the date for modified is greater than X period then export it/copy it and then delete it.

     

    One thing to remember is that you would want to add an extra column of data if you put it into another list, so that you can track the original row id in the sharepoint list.

     

    Which leads to another issue, from an auditing etc perspective, if you remove them and then later need to lookup all the changes to X row, you have to cross match them. And if you have since removed all the rows related to changes and want to put them back, the issue is these rows wont have the same rowid in sharepoint.

     


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard