unable to access OneDrive for Business
My entire tenant is unable to access OneDrive even though all users are assigned either an E3 or M365 Premium license. OneDrive client apps no longer connect, can't attach files to chats/channels within Teams, can't access user OneDrive links in the Admin Center, and Teams meeting recordings will not upload automatically to OneDrive. Support ticket has been opened but they are stumped and my company is suffering from this. We have troubleshooted everything! Any help is appreciated. Thank you.
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()
