I tested SharePoint auto-trimming behavior against files with and without retention labels. The results show that files without a retention label are trimmed as expected, while files with a retention label behave more like retention policy items and keep versions longer. For non-retention-label files, SharePoint trims old versions once the version count grows. Auto-trimming bypasses the recycle bin and removes older minor/major versions. However, files with retention labels appear to retain versions instead of trimming them.

Updating SharePoint file metadata with Set-PnPListItem requires the correct UpdateType. Use SystemUpdate for author and retention label changes, and UpdateOverwriteVersion when updating the editor. When to use SystemUpdate SystemUpdate updates list item metadata without creating a new version or changing the modified date. It is ideal for author changes or retention label updates. When to use UpdateOverwriteVersion UpdateOverwriteVersion updates metadata and creates a new version. It is required for editor changes because SystemUpdate does not update the editor field reliably.

Summary SharePoint MCP (Model Context Protocol) tools may be missing in Copilot Studio due to Copilot Frontier access settings. Enable SharePoint MCP tools by configuring access in Microsoft 365 Admin Centre under Copilot Control System. Grant “All Users” access to Web Apps in Copilot Frontier settings. Tools typically appear in Copilot Studio within minutes after enabling. Table of Contents The Problem What Are SharePoint MCP Tools Solution: Enable Copilot Frontier Access Step-by-Step Configuration Verification References The Problem When building agents or custom copilots in Copilot Studio, you may find that SharePoint MCP tools are missing from the available connectors or tools list.