For a more controlled archiving to a database we recommend the kalmstrom.com Silver solution SP Archive.) Show
Follow kalmstrom.com on LinkedIn, Facebook or Twitter!
This blog walks you through the process of how to archive SharePoint lists using Microsoft Power Automate flow and focuses on a SharePoint list which has column types such as Multiple lines of text, Hyperlink or Picture, Choice and Lookup type columns. In addition, the Multiple lines of text column has the append changes to an existing text option selected as yes. ScenarioConsider a SharePoint list whose list items need to be archived i.e. copied over to either another SharePoint list or a data source such as Excel or Azure SQL table or CDS entity. The source list has some complex SharePoint columns such as
Here are screenshots of the list and their column types:  Comments column and its settings: Here is a screenshot of the destination list: As you can see the comment column in the destination list does not have the append feature set as yes: Power Automate flowThe Power Automate flow does a great job copying the Single line of text and Hyperlink or Picture directly, however, the Choice type column and the Multiple lines of text with append does require some extra work. To copy the Choice type columns, we use the variable function and for Multiple lines of text with append, we use a combination of HTTP request and HTML table. VideoThis video walks you through the two SharePoint lists and the flow. ConclusionThe destination is also a SharePoint list, however, you can use other data sources such as an Excel spreadsheet in OneDrive, Azure SQL Table or CDS entity. Keep in mind if you do use Azure SQL Table or CDS entity then you will need either Power Automate per-flow or per-use plan in addition to your Office 365 license. This is how you should archive SharePoint lists using Microsoft Power Automate flow! Read my previous blog posts and see the videos for more great how-tos and tips & tricks: Build your own Audit App *** Interested to see how you can make your workday more efficient? Why not book a free demo. Let us show you how our tools can help to re-engage and motivate your staff! BOOK A FREE DEMO Over 15 years of experience has brought about a dynamic spirited and performance driven professional which a blend of leadership and business knowledge. Recognized by Microsoft for writing blogs and videos in the Power Platform Community regarding the Power Platform and it’s integration with Azure Cognitive Services, OneDrive, SharePoint and SQL. As an active speaker and influencer at events and social media, Daniel demonstrates his passion of being a big proponent of sharing his knowledge and experience.
asked • Aug 27, '20 | JerryXu-MSFT commented • Sep 2, '20
I have sharepoint list having the data from last 2 years in SharePoint online I want to move the archive data of this sharepoint liist to some list in SharePoint onlineHow we can achieve this ?how many methods? Is there any possibility to archive this data by using workflows? Comment |
