Better way to Archive and Delete large SharePoint List.

%3CLINGO-SUB%20id%3D%22lingo-sub-1363492%22%20slang%3D%22en-US%22%3EBetter%20way%20to%20Archive%20and%20Delete%20large%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363492%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECurrently%20I%20have%20a%20Power%20App%20that%20is%20connected%20to%202%20SharePoint%20lists.%20Both%20of%20these%20lists%20accumulate%20around%203-4%20thousand%20lines%20each%20month.%20At%20the%20end%20of%20the%20month%20I%20archive%20whats%20on%20the%20lists%20and%20then%20delete%20the%20data.%20There%20are%20two%20issues%20I%20am%20encountering.%20When%20deleting%20the%20data%20on%20the%20lists%20this%20takes%20FOREVER.%20I%20have%20to%20use%20the%20select%20all%20button%20and%20keep%20scrolling%20until%20all%20the%20data%20is%20actually%20selected%20and%20then%20it%20deleting%20off%20SharePoint%20takes%20some%20time%20also.%20The%20second%20issue%20I%20have%20is%20one%20of%20the%20lists%20are%20pictures%20(JPG).%20So%20when%20I%20archive%20these%20images%20and%20then%20delete%20them%20off%20SharePoint%20I%20am%20unable%20to%20view%20the%20Images%20anymore%20since%20the%20archive%20is%20a%20link%20to%20the%20images%20on%20SharePoint.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20Access%20to%20import%20from%20SharePoint%20and%20also%20One%20Drive.%20Any%20faster%20solutions%20to%20deleting%20and%20being%20able%20to%20view%20the%20images%20at%20a%20later%20date%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1363492%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello,

Currently I have a Power App that is connected to 2 SharePoint lists. Both of these lists accumulate around 3-4 thousand lines each month. At the end of the month I archive whats on the lists and then delete the data. There are two issues I am encountering. When deleting the data on the lists this takes FOREVER. I have to use the select all button and keep scrolling until all the data is actually selected and then it deleting off SharePoint takes some time also. The second issue I have is one of the lists are pictures (JPG). So when I archive these images and then delete them off SharePoint I am unable to view the Images anymore since the archive is a link to the images on SharePoint. 

 

I have used Access to import from SharePoint and also One Drive. Any faster solutions to deleting and being able to view the images at a later date?

0 Replies