Announcements
Can anyone recommend a Power Apps video detailing how to manage large amounts of data/records where once a certain amount of records are reached, they are moved to an archived table? In this instance, the data sources would be SharePoint lists. I also know Dataverse so I would not rule out looking at a Dataverse based tutorial.
Just run a scheduled flow in powerautomate, have it run every morning and have it pull the most recent X numbe rof rows from the list, then set a variable to the last records id which will be the max number of itesm to keep.
then run another get items in which the odata filter is any id that is lt the previously gathered id number
Expression for that Variable is
last(outputs('Get_items_3')?['body']?['value'])?['ID']
then the second get items
@TheRobRush - Thank you for your response! In your scenario, Power Automate would move any older records to a new SP list/table while retaining the most recent 2000 records?
In the screenshot I sent it will take anything past the last 250 (First Get is set to 250 items) the 2000 in second is just the max it can move at one time. You then need to add the create items, and the delete item after
@TheRobRush - Thank you for the additional info.
Can anyone recommend a video demonstrating these methods?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional
