Rename files in OneDrive or SharePoint Document Library
Hello, I've been trying to rename files in OneDrive Business or SharePoint Document Library but have only been able to get as far as renaming the files locally. My goal is to rename files in a SharePoint document library subdirectory (or OneDrive), where Powershell will rename the files based on data from Excel columns/rows. The Document Library contains files named: 1234-0087-080323.pdf My Excel file (or I can create a SharePoint list if needed) has two columns; Column A is the Account Number; for example "888-0087". I would like to look up the Excel file and rename the file if it contains a part of Column A, the account number (i.e. 0087), then rename it to the corresponding account name in Column B. ColumnA ColumnB Account Number Account Name 888-0087 Account Here's what I have so far: $excelFile = 'C:\test\test.xlsx' # xlsx being with Name in col 1 and acct # in col 2 $tempFolder = 'C:\test\temp\' # where the files to be renamed live #opens workbook $excel = New-Object -ComObject Excel.Application $excel.Visible = $false $workbook = $excel.Workbooks.Open($excelFile) $worksheet = $workbook.Worksheets.Item(1) $i = 1 while ($worksheet.Cells.Item($i, 1).Value() -ne $null) { $id_no = $worksheet.Cells.Item($i, 2).Value() $old_f = Get-ChildItem $tempFolder | Where Name -match ($id_no) | Select FullName if ($old_f.FullName -ne $null) { $start = $tempFolder.Length + $id_no.Length $datestr = $old_f.FullName[$start..$old_f.FullName.Length] -join '' $new_f = ($worksheet.Cells.Item($i, 1).Value() + $datestr) if (Test-Path -Path $old_f.FullName) { if ((Test-Path -Path $tempFolder$new_f) -eq $true) { Write-Host $tempFolder$new_f "already exists. NOT RENAMED" } if ((Test-Path -Path $tempFolder$new_f) -eq $false) { Rename-Item -Path $old_f.FullName -NewName $new_f Write-Host $old_f.FullName "renamed to" $new_f } } } $i++ } $excel.Quit # IMPORTANT: clean-up used Com objects [System.Runtime.Interopservices.Marshal]::ReleaseComObject($worksheet) | Out-Null [System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null [System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null [System.GC]::Collect() [System.GC]::WaitForPendingFinalizers()How to Detect Files of the Same Size on your Computer via PowerShell
Learn how to use PowerShell to detect files of the same size on your computer quickly and easily. This article provides a script to automate the process and save storage space. Follow the step-by-step instructions and improve your file management skills with PowerShell automation.
