Power Automate Archive SharePoint List Item
Power Automate
Jun 14, 2022 12:00 AM

Power Automate Archive SharePoint List Item

by HubSite 365 about Shane Young [MVP]

SharePoint & PowerApps MVP - SharePoint, O365, Flow, Power Apps consulting & Training

Citizen DeveloperPower AutomatePower SelectionLearning Selection

Power Automate Archive SharePoint List Item Shane shows in this video how to optimize SharePoint list data retention.

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.

  • It Starts
  • Reasons you want to make your SharePoint list smaller with archiving
  • Create a flow to archive in Power Automate
  • Add the SharePoint Get Items action with an odata filter and limit top count
  • Looking at the flow output to understand the data and what you want to filter against
  • Power Automate odata filter a date column
  • Creating a SharePoint list from existing list
  • Create item in SharePoint via an Apply To Each loop
  • SharePoint Delete Item in Power Automate flow
  • Subtract from time and utcNow in Power Automate
  • Using a terminate action to make flow testing easier and faster
  • Change the trigger to Recurrence-

Learn about Power Platform University at