PS Script for SharePoint Online to Pull Filename w Extension, Uploaded during a Time Period

MCT

Jul 25, 2024

here is the powershell script you can use

# Install the SharePoint Online Management Shell module if you haven't already
Install-Module -Name Microsoft.Online.SharePoint.PowerShell -Scope CurrentUser

# Connect to SharePoint Online
$adminUPN = "your_admin_email@your_domain.com"  
$siteUrl = "https://your_tenant.sharepoint.com/sites/your_site_name"
Connect-SPOService -Url $siteUrl -Credential (Get-Credential -UserName $adminUPN)

# Define time range
$startTime = Get-Date "2024-07-20T00:00:00Z"   # Example start time (adjust as needed)
$endTime = Get-Date "2024-07-25T23:59:59Z"   # Example end time (adjust as needed)

# Get all files in the site within the time range
$allFiles = Get-PnPListItem -List Documents -PageSize 500 -Fields Title, TimeLastModified, File_x0020_Size 
$allFiles = $allFiles | Where-Object { $_.TimeLastModified -ge $startTime -and $_.TimeLastModified -le $endTime }

# Create a custom object to hold file information
$fileData = @()
foreach ($file in $allFiles) {
    $fileInfo = [PSCustomObject]@{
        FileName = $file.FieldValues.Title
        LastModified = $file.FieldValues.TimeLastModified
        FileSizeInBytes = $file.FieldValues.File_x0020_Size
        FileSizeMB = "{0:N2}" -f ($file.FieldValues.File_x0020_Size / 1MB)  # Convert to MB, format to 2 decimal places
    }
    $fileData += $fileInfo
}

# Display the results in a table
$fileData | Format-Table -AutoSize

# Disconnect from SharePoint Online
Disconnect-SPOService

Forum Discussion

PS Script for SharePoint Online to Pull Filename w Extension, Uploaded during a Time Period

Resources