新手求助：本地文件夹全量上传至SharePoint Online General文件夹报错

Hey there! Let's break down why you're hitting that parameter count error and fix your upload script step by step.

The Core Issues #

Your SaveBinaryDirect call is failing for two key reasons:

1. You're using an absolute URL instead of a server-relative URL: The method expects a server-relative path (like /sites/YourSite/General/A/file.txt) instead of a full absolute URL (e.g., https://tenant.sharepoint.com/sites/YourSite/...).
2. Uncontrolled path concatenation: Manual string splicing creates messy paths (like double slashes) or, worse, if folder names have spaces, PowerShell splits your URL into multiple parameters—triggering that "four arguments" error.

Fixed Code & Explanation #

Here's a revised version of your code that addresses these problems:

# First, load your target "General" folder correctly (adjust the site path to match yours)
$web = $script:context.Web
$targetRootFolder = $web.GetFolderByServerRelativeUrl("/sites/YourSite/General")
$script:context.Load($targetRootFolder)
$script:context.ExecuteQuery()

# Loop through all files in your local nested folder structure
foreach ($file in Get-ChildItem -Path $localFolder -Recurse -File) {
    # Calculate the relative path from your local root to the current file
    $localRelativePath = (($file.DirectoryName).Replace($localFolder, '')).Replace('\', '/').TrimStart('/')
    
    # Build the valid server-relative path for the target file
    $targetFileRelativeUrl = if ([string]::IsNullOrEmpty($localRelativePath)) {
        # File is in the root of your local folder
        "$($targetRootFolder.ServerRelativeUrl)/$($file.Name)"
    } else {
        # File is in a nested subfolder
        "$($targetRootFolder.ServerRelativeUrl)/$localRelativePath/$($file.Name)"
    }
    
    # Clean up accidental double slashes (optional but safe)
    $targetFileRelativeUrl = $targetFileRelativeUrl -replace '//+', '/'
    
    # Open the local file stream for reading
    $fs = [System.IO.File]::OpenRead($file.FullName)
    
    # Upload the file with properly formatted parameters
    [Microsoft.SharePoint.Client.File]::SaveBinaryDirect($script:context, $targetFileRelativeUrl, $fs, $true)
    
    # Always close the stream to avoid file locks
    $fs.Close()
}

Key Fixes Breakdown #

• Server-Relative Paths: $targetRootFolder.ServerRelativeUrl gives you a pre-built, valid path to your "General" folder—no need to manually concatenate the site URL.
• Clean Relative Paths: TrimStart('/') removes leading slashes from your local path, preventing invalid double slashes like /General//A/file.txt.
• Avoid Parameter Splitting: Building the target URL into a single variable ensures PowerShell treats it as one argument, even if folder names contain spaces.
• Proper Stream Handling: Explicitly opening and closing the file stream prevents resource leaks and locked files.

Quick Verification Checks #

1. Ensure $localFolder is an absolute path (e.g., C:\MyLocalFiles) with no trailing slash.
2. After loading $targetRootFolder, run $targetRootFolder.ServerRelativeUrl to confirm it's a valid server-relative path.
3. Print $targetFileRelativeUrl before the upload call to verify it has no absolute URLs or double slashes.

内容的提问来源于stack exchange，提问作者tarou chabi