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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Setup a flow to archiv...
Power Automate
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?


 

 

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    52,985 Super User 2025 Season 2 on at

    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

  • SPS-DEV-22 Profile Picture
    516 on at

    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.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard