Power Automate Archive SharePoint List Item

Learn about Power Platform University at https://training.powerapps911.com/pages/coming_soon

Learn how to use a Recurrence flow that gets all of the items from SharePoint that needs archived based on their date. Then create a copy of the item and delete the item. Power Automate Archive SharePoint List Item uses an oData query against the date to find old items and passes it to an apply to each loop. Also, the date to archive from is auto calculated using utcNow and Subtract time from date.

0:00 It Starts
0:28 Reasons you want to make your SharePoint list smaller with archiving
1:15 Create a flow to archive in Power Automate
1:52 Add the SharePoint Get Items action with an odata filter and limit top count
3:50 Looking at the flow output to understand the data and what you want to filter against
5:40 Power Automate odata filter a date column
8:34 Creating a SharePoint list from existing list
9:45 Create item in SharePoint via an Apply To Each loop
13:01 SharePoint Delete Item in Power Automate flow
15:40 Subtract from time and utcNow in Power Automate
17:26 Using a terminate action to make flow testing easier and faster
19:39 Change the trigger to Recurrence

Power Apps Consulting and training at https://www.PowerApps911.com
Be the first to comment