How to Integrate Salesforce with Microsoft SharePoint Using Files Connect?

Integrate Salesforce with Microsoft SharePoint Using Files Connect

Imagine your Salesforce CRM is a high-speed engine, but heavy document storage is acting like a lead weight, slowing performance and inflating costs. For many, the "Storage Full" alert is a constant headache. While Salesforce is a premier platform for customer data, its native file storage is highly limited and costly. Meanwhile, Microsoft SharePoint is an enterprise-grade powerhouse offering massive capacity and robust document management.

By connecting these two via Files Connect, you aren't just clearing up a digital attic; you're bridging the gap between customer data and document collaboration. This integration creates a "single pane of glass" where your team can search, view, and edit SharePoint files without ever leaving their Salesforce record.

At Minuscule Technologies, Trusted Salesforce Engineering Partner, we specialize in architecting these seamless bridges. We help you navigate the technical maze of Azure API permissions and metadata mapping to ensure your "Files Connect" setup is secure and scalable.

Ready to stop paying for duplicate storage and start working smarter? Read our full integration guide below or let’s discuss a custom strategy for your business.

Why Choose Files Connect for SharePoint Integration?

Salesforce Files Connect is the native, "point-and-click" solution provided by Salesforce to surface external documents without duplicating them. Here is why it remains the go-to for many enterprises:

  • Native Search: SharePoint files appear in Salesforce Global Search results.
  • Zero Duplication: Files stay in SharePoint. Salesforce simply "references" to them, ensuring your source of truth remains singular.
  • Security Alignment: Files Connect respects SharePoint permissions. If a user shouldn't see a file in SharePoint, they won't see it in Salesforce either.
  • Cost Efficiency: Most Salesforce licenses (Enterprise and above) include Files Connect for at least one external system at no extra cost.

Pre-Integration Checklist: The 4 Guiding Principles

Before touching any settings, consider these strategic pillars to ensure a smooth rollout:

  • Data Residency: Does your data need to stay in a specific geographic region (e.g., GDPR compliance)? Ensure your SharePoint site is provisioned in the correct locale.
  • Security Mapping: Decide if Salesforce users should inherit their existing SharePoint permissions (Per User) or use a single master credential (Named Principal).
  • Data Architecture: Salesforce is "flat," while SharePoint is "hierarchical." Map out how folders should be categorized before you sync to avoid a disorganized system.
  • External Sharing: If you use Salesforce Experience Cloud, define exactly which SharePoint files external partners or customers are allowed to view.

Step-by-Step Guide: Setting Up Salesforce Files Connect

To follow this guide, you will need System Administrator access to both Salesforce and your Microsoft Azure/Office 365 environment.

Step 1: Enable Files Connect

  • In Salesforce Setup, search for Files Connect. Click Edit and check Enable Files Connect. Choose Reference mode to point directly to SharePoint and save storage space.

Step 2: Set Up User Permissions

  • Create a Permission Set (e.g., "Files Connect Permissions"). Under System Permissions, enable Files Connect Cloud. Assign this to your target users.

Step 3: Create an Auth Provider

  • In Salesforce Setup, go to Auth. Providers and click New. Select OpenID Connect. Use a placeholder name like "SharePoint." You will need the Callback URL generated at the bottom of this page for the next step.

Step 4: Register the App in Microsoft Azure

Log into the Azure Portal. Under App Registrations, create a new registration.

  • Paste the Callback URL from Salesforce into the Redirect URI field.
  • Generate a Client ID and Client Secret.
  • Grant necessary API permissions (Files.Read.All, Files.ReadWrite.All).

Step 5: Define SharePoint as an External Data Source

Go back to Salesforce Setup > External Data Sources.

  1. Click New, set Type to Files Connect: Microsoft SharePoint Online.
  2. Paste your SharePoint Site URL.
  3. Link it to the Auth Provider you created in Step 3.
  4. Click Validate and Sync.

Frequently Asked Questions  

1. Can I automatically upload a Salesforce file into SharePoint using Files Connect?

No. Native Salesforce Files Connect is primarily an "inbound" tool designed for browsing, searching, and referencing existing SharePoint files within the Salesforce UI. If your workflow requires "outbound" automation—such as automatically moving a file uploaded in Salesforce over to a specific SharePoint folder—you will need a third-party AppExchange tool like's Files or a custom Apex/Microsoft Graph API integration.

2. Do users need a separate Microsoft SharePoint license to view files in Salesforce?

This depends on your configuration. If you choose "Reference" mode (the most common for saving storage), users do need a SharePoint license and must authenticate with their Microsoft credentials to view or download the file. If you use "Copy" mode, a duplicate is created in Salesforce, allowing users without SharePoint access to see it, but this does not save on Salesforce storage costs.

3. Why am I seeing a "Correlation ID" error during the Azure handshake?  

A Correlation ID error typically points to a mismatch in the Redirect URI or insufficient permissions in the Azure App Registration. Ensure that the Callback URL generated in Salesforce matches the Redirect URI in Azure exactly (including the trailing slash). Also, verify that "Admin Consent" has been granted for the Files.Read.All and Sites. Read.All permissions in the Azure portal.

4. Can I search for text inside a SharePoint PDF from the Salesforce search bar?  

Yes, but with conditions. Salesforce Global Search can query the metadata (Title, Author, Custom Columns) of SharePoint files immediately. However, searching the content within a document (OCR) depends on whether SharePoint has finished indexing that file and whether the Salesforce External Object is configured to allow "Full Text Search."

5. Is Files Connect compatible with SharePoint "On-Premise" versions?  

Salesforce has shifted its primary support toward SharePoint Online (Office 365). While older versions of SharePoint On-Premise could be connected using a "Cloud Connector" or an OData producer, it is highly recommended to migrate to SharePoint Online to utilize the native v2.0 Graph API connectors, which offer better security and faster sync speeds.

Conclusion: Seamless Collaboration with Minuscule Technologies

Integrating SharePoint and Salesforce using Files Connect is the most effective way to eliminate silos and manage costs. However, the 23-page setup process and the complexities of Azure API permissions can be a significant hurdle for busy IT teams.

At Minuscule Technologies, we specialize in architecting these bridges. We don't just "connect" systems; we optimize your data flow to ensure your sales and support teams spend less time searching for files and more time delivering value. Whether you need a standard Files Connect setup or a highly automated custom integration, our years of experience ensure your document strategy is scalable, secure, and cost-effective.

Ready to stop paying for duplicate storage and start working smarter?  

Consult with Minuscule Technologies today. We will perform a free audit of your current file storage and help you build a SharePoint integration that fuels your business growth.

Contact Us for Free Consultation
Thank you! We will get back in touch with you within 48 hours.
Oops! Something went wrong while submitting the form.

Recent Blogs

Ready to Architect Your Salesforce Success?

You've seen what's possible. Now, let's make it happen for your business. Whether you need an end-to-end Salesforce solution, a complex integration, or ongoing managed services, our team is ready to deliver.

Schedule a Free Strategic Call