What problem does it solve?
Integrating with SharePoint Online for file management, data synchronization, or automated reporting can be complex due to authentication, large file handling, and API choices. This Skill provides battle-tested patterns using both CSOM and Microsoft Graph API to automate these interactions reliably and efficiently.
Core Features & Use Cases
- Robust File Uploads: Upload files to SharePoint with automatic chunking for large files, handling folder creation and existence checks.
- Excel Data Automation: Programmatically update specific cells or ranges within Excel files stored in SharePoint using the Microsoft Graph API.
- Folder & File Management: Create entire folder hierarchies, check file existence, and download files from SharePoint with ease.
- Use Case: Automate a daily process to upload a large batch of generated reports to a specific SharePoint folder, update a central Excel tracker with the upload status, and download a configuration file from another SharePoint location for processing.
Quick Start
Use the SharePoint skill to upload the attached 'large_report.pdf' to the '/sites/MySite/Documents/Reports/2025' folder, ensuring it handles chunked uploads for large files.