Question

Hello

I have a task with Powershell. I need a script to delete files by name in a folder located on SharePoint on-premise. The files start with specific later and ended with

_final.

what we need:

Only focus on files that start with BLG_STOCK.

We need 1 file per month, based on the filename (not the publishing date):

• for the current month: only the last file (today).
• For every previous month: only the last file of that month needs to remain. We are allowed to add something like _FINAL (if that would help us).

Yes, I only need to have the "BLG_STOCK_final" per month. All others files starting with BLG_STOCK (without _final) need to be deleted.

Answer 1

Here is the best answer for this question:

I have created a folder named HomeworkLib with below files in my Document library:

I executed the script from powershell:

Please enter your sharepoint online username and password when asked.

Script execution status:

So script completed without any issues.

We will check the sharepoint library now

It deleted all the files except BIG_STOCK_final.

Script code:

Code in text format:

# Input Parameters. Please update both as per your needs.  
$siteURL="https://xxxxxxx.sharepoint.com/sites/mytestsite"   
$folder="Shared Documents/HomeworkLib"
  
# Function to get all the files details in the given folder
Function GetFiles($folderUrl)
{
   # Getting files details
$FilesList=Get-PnPFolderItem -FolderSiteRelativeUrl $folderUrl -ItemType File

   # If files are not there, then showing a message and exiting
if($FilesList.Count -eq 0)
{
   write-host -ForegroundColor Green 'No files are available'
break;
}
else
{
# If files are there, then reading each files name
foreach($file in $FilesList)
{   
           # deleting the file if file name is not 'BLG_STOCK_final'
           IF (Compare-Object $file.Name "BLG_STOCK_final")
           {
                  
               $deleteFile= $folderUrl+"/"+$file.Name
               Remove-PnPFile -SiteRelativeUrl $deleteFile -Force

           }
       }
   }
}
  
# Connect to SharePoint Online site   
Connect-PnPOnline -Url $siteURL -Credentials (Get-Credential)
  
# Call the function to get the files details
GetFiles($folder)

Notes:

• Update the script with correct site URL
• Update the script with correct folder path where you have placed the files
• Test the script with some sample data before executing it on actual files
• If Pnp module is not installed on your system, then open powershell and enter the below command:

Install-Module SharePointPnPPowerShellOnline

Please hit the like button if my answer was helpful. Thanks in advance.