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?
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.
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