SalesPoint · Installation guide

Set up SalesPoint in Salesforce

Your SharePoint & Salesforce integration is almost ready, just one quick setup to go. This guide walks you through connecting your SharePoint site to your Salesforce org and adding the component to your Lightning pages.

Before you start

How SalesPoint works

SalesPoint links Salesforce records to folders on your SharePoint site. Setup has three parts: the connection in Salesforce, a Trusted URL for your SharePoint domain, and the component on your Lightning pages.

Checklist

  • The SalesPoint package is installed in your Salesforce org.
  • You have a Microsoft account that can grant admin consent for your Microsoft tenant.
  • You know your SharePoint domain, e.g. https://resolveit.sharepoint.com.
  • You can create fields and edit Lightning pages in Salesforce.
Step 1

Salesforce setup

Connect your SharePoint site to your Salesforce org.

App Launcher › SharePoint App

  1. 1

    Assign permission sets

    Assign the right Permission Set(s) to your users. At minimum, assign SharePoint Admin Access to your own user so you can complete the next steps.

    The permission sets SharePoint Admin Access and SharePoint User Access
  2. 2

    Open the SharePoint app

    Go to the App Launcher and search for SharePoint App. Open it: by default it opens the app’s home page.

    The App Launcher with the search result SharePoint App
  3. 3

    Start granting access

    On the home page, click the “Click me” area on the right. A new tab opens so you can grant access to the SharePoint app.

    SharePoint app home page with the Microsoft admin consent required panel and the Click me button on the right
  4. 4

    Accept the permission request

    In the new tab, accept the app’s permission request. You’ll then be redirected to the Salesforce login page.

    The Microsoft permission request for the SharePoint app
  5. 5

    Use the right login URL

    By default you’re redirected to login.salesforce.com. If you installed the app in a Sandbox, replace it with test.salesforce.com.

    Address bar showing login.salesforce.com
  6. 6

    Log in & confirm

    Log in with your Salesforce org. A “Connection successful” message pops up. Close it: you return to the app home page (now showing a different image). Click Next.

    The Connection successful message
    SharePoint app home page after connecting, with the Next button
  7. 7

    Create a new connection

    Choose Create a new connection and give the connected SharePoint site a clear, generic name. Click Next.

    The option to create a new SharePoint connection, with the Sharepoint Setting Name field
  8. 8

    Choose the root folder

    Select the Site ID (or a folder inside it) as the root folder where dynamic folders will be created (e.g. site “Salesforce Demo”, folder “Test Folder”). Click Next.

    The Select a SharePoint Site list with folders inside the SalesforceDemo site
  9. 9

    Set profiles, file types & delete rights

    On the final screen, set three things: the profiles that may access the app, the accepted file formats (e.g. pdf, docx), and the users allowed to delete SharePoint files from within Salesforce.

    Settings for profile access to the app
    Settings for accepted file formats
Installing in a Sandbox? When you log in (step 5), replace login.salesforce.com with test.salesforce.com, otherwise the connection fails.
Step 2

Trusted URL configuration

Allow your SharePoint domain in Salesforce so the component can load files and previews. Fill in the fields below and click Save.

Setup › Trusted URLs › New Trusted URL

FieldValue
API NameA name without spaces or special characters, e.g. companyname_Sharepoint
URLhttps://yourdomain.sharepoint.com (your own SharePoint domain)
ActiveChecked
CSP ContextAll
connect-src (scripts)Checked
font-src (fonts)Checked
frame-src (iframe content)Checked
img-src (images)Checked
media-src (audio & video)Checked
style-src (stylesheets)Checked

💡 Your SharePoint domain is the URL you use to open SharePoint, e.g. https://resolveit.sharepoint.com.

Step 3

Lightning page configuration

Add the SharePoint component to your object pages.

How folder matching works: when you connect an object to SharePoint, it first checks the designated location for a folder whose name matches the record name. If one exists, it’s linked automatically (so no duplicate folders are created); if not, a new folder is created.
  1. 1

    Create two text fields per object

    On every object you want to link with SharePoint, create two text fields: one to store the SharePoint Folder ID and one to store the Pinned Folder ID.

    The SharePoint Folder Id text field in Object Manager
    Example: SharePoint_Folder_Id__c and Pinned_Folder_Id__c.
  2. 2

    Add the component to the Lightning page

    Open the Lightning App Builder and drag & drop the SharePoint component onto any Lightning page.

    The sharepoint component under Custom in the Lightning App Builder, and the component on a record page
  3. 3

    Configure the component

    Settings can differ per object. The numbers match the screenshot.

    SettingDescription
    1 Sharepoint Field Api of this ObjectAPI name of the field that stores the SharePoint Folder ID.
    2 Pinned Folder Field Api of this ObjectAPI name of the field that stores the Pinned Folder ID.
    3 Main Folder Object Api Name of the RecordAPI name of the object the component works for.
    4 Api Name of parent object for creating relationship(Optional) API name of the parent object, only if you want to relate the record to another object in the folder tree.
    5 Sharepoint Field Api on Parent Object(Optional) API name of the field where the SharePoint ID is stored on the parent object.
    6 Folder LabelAPI name of the field that defines the folder name on SharePoint (default = record name).
    7 Maximum Height of this component(Optional) A maximum height for the Lightning component.
    8 Select a Sharepoint Site to connectSelect which SharePoint site to connect: the one you created in the Salesforce setup steps.
    SharePoint component configuration panel with the settings numbered 1 to 8
    Example for Account, with the folder name based on name.

    The Salesforce Files checkbox: when enabled, files created as Salesforce Files by (external) users or apps are automatically copied to SharePoint as well.

  4. 4

    Save & activate

    Save and activate the Lightning page. SalesPoint is now live on that object.

Need a hand?

Our consultants are happy to help with the setup or a guided onboarding.