Install the Next-Generation SharePoint Connector

Showpad’s SharePoint app syncs assets from SharePoint to Showpad. Once the integration has been set up and configured in Showpad, SharePoint acts as the single source of truth for the synced assets and the mapped metadata. The configuration includes:

• Authentication and authorization to the source system.
• Filter criteria to determine which assets need to be synced to Showpad.
• A mapping to indicate which properties in Showpad must be defined based on values in SharePoint.

The app performs a one-way sync from SharePoint to Showpad and overwrites any manual changes to the mapped properties in Showpad. Showpad makes content governance easier throughout every stage of the content lifecycle. Once set up, it reduces the manual effort of content management in a compliant and secure way.

Showpad’s SharePoint app enables you to distribute your SharePoint content in a branded environment that your sales reps can access on Showpad's Web App and every mobile device with our apps and email integrations, online and offline.

See how it looks

Key features

• Use SharePoint as your single source of truth
• Understand how and when your SharePoint content is used with Showpad
• Define Showpad asset properties based on SharePoint (column) metadata
• Reliability. If the connection between SharePoint and Showpad is interrupted, your processed documents are still available in Showpad.
• The SharePoint app only needs to be installed once by an admin and added to each relevant SharePoint site. Showpad users don’t need to take any action to use this feature.
• Connectivity. Multiple SharePoint instances/Document Libraries can be connected with multiple Showpad Divisions.

You need this to succeed

The quick way

1. Install the SharePoint app and authorize the integration
2. Configure the integration
   • Connect to SharePoint
   • Select Assets
   • Map Attributes
   • Confirm Configuration
3. Find details in the dashboard
4. Property Reference Table
5. User Permissions
   • Delegate Permissions
   • Consent for Organization

Do this step by step

Install SharePoint App

You can install the SharePoint app from the Admin App.

1. Click the gear icon to open Settings.
2. In the Showpad Apps section, select Manage Apps.
3. Click Install App.
4. Select the SharePoint app to install. Be sure the Automatically install the new version when the available checkbox is enabled (default).
5. Click Install.
6. Once the app is installed, you'll need to authorize the integration.

Authorize Integration

The first time you open the SharePoint app, you'll be asked to authorize the integration with SharePoint. To do so, click the Authorize button.

Configure Integration

Connect to SharePoint

1. In the Admin App, click the gear icon to open Settings.
2. In the Showpad Apps section, select SharePoint.
3. Click the Add new connection button.
4. Select the Division to connect with and click the Connect to SharePoint button. This ensures that your connection knows which Division to sync assets to. If you don't have multiple Divisions, the dropdown list is not displayed.
5. Select how to connect:

   Note: A SharePoint Administrator is required for consent.

   • Connect with app permissions: This option provides application-level permissions. It authorizes full access for the Showpad app to operate within SharePoint. This connection is not linked to a specific user. Authorization scope: Sites.Read.All
   • Connect with delegated permissions: This option provides user-level permissions. It authorizes limited access as an individual user. Only content and features accessible to the authorized user are available. See the User Permissions section to learn more about setting this up. Authorization scope: Sites.Read.All offline_access
6. This will open an external window, allowing you to log into Microsoft and enable the Showpad app to read and create assets. When ready, click the Accept button.
7. Click Next.

Select assets

This step is used to specify which assets need to be synced to Showpad.

1. Enter or select the SharePoint Site or subsite to use.
   When selected, you’ll be able to specify the Document Library to use.
2. If the selected Document library contains Yes/No, Text, or Choice columns, you can define the columns and their values for the asset filter. Only assets meeting the filter criteria will be synced to Showpad.
   Click the Add column/value button to define additional columns and values. You can remove columns and values by clicking the minus icon.
3. Optionally, the Exclusions section allows you to define specific file types and tags to exclude.
   • Ignored File Types: This is a list of file types that will never be synced (even if Showpad supports them). From the dropdown list, select the types of files you don't want to sync.
   • Ignored Tags: This is a list of tags that will never be synced (even if they exist in Showpad). Enter the tags that should not be created or assigned.
4. Click the Next button.
5. Click Yes, continue to confirm the sync.

Map Attributes

Attribute mapping determines which Showpad properties correspond to the columns in the Source (SharePoint).

It’s important to note that properties specified in the mapping are controlled from the Source (SharePoint) and should not be modified in Showpad. This means that every time an asset gets synced, its value in Showpad will be recalculated and overwritten by SharePoint. Any changes made to a property within Showpad will be lost. If you want to maintain control of a certain property within the Showpad Library, do not map it here.

1. Select the column in SharePoint that corresponds to the Name property in Showpad. This mapping is mandatory. All other mappings are optional. See the description of the Showpad properties that can be mapped.
   You can define additional mappings by clicking the Add Showpad property button. Click the trash icon to remove a mapping. Depending on the property, you can add advanced mapping options by clicking the caret next to the dropdown list: This opens more options you can configure:
   Clicking Add response mapping enables you to translate specific SharePoint values to their equivalent in Showpad. In the example below, the response mapping states:
   If the Audience equals 'Customer Facing' in SharePoint, then the 'Can be shared' property should be set to 'Yes'.
   See the Property Reference Table for full details.
2. When you’ve completed the mapping, click the Next button.

Confirm Configuration

The last step lets you review your configuration and specify the sync frequency.

1. From the Sync frequency dropdown list, select the frequency that data is synced between Showpad and SharePoint. The default frequency is 15 minutes, meaning that the systems will sync every 15 minutes. The following frequencies are supported:

   Frequency	Description
   15 mins	(default) The data is synced every 15 minutes.
   30 mins	The data is synced every 30 minutes.
   1 hour	The data is synced every hour.
   2 hours	The data is synced every 2 hours.
   3 hours	The data is synced every 3 hours.
   4 hours	The data is synced every 4 hours.
   6 hours	The data is synced every 6 hours.
   8 hours	The data is synced every 8 hours.
   12 hours	The data is synced every 12 hours.
   24 hours	The data is synced every 24 hours.

2. Select the Enabled option to immediately enable the sync. If you leave this unselected, the sync will be saved in a disabled state, ready to be enabled at a later point in time.
3. Click the Save connection button

Once saved, an overview of the configuration is displayed

Icons are available for you to perform the following actions:

• Enabled: Toggle the switch to enable or disable the sync.
• Re-sync: To trigger an immediate resync of all assets, click the icon. This won't affect the set frequency schedule.
• Re-authorize Showpad: To re-connect to SharePoint, click the three dot menu next to the Add connection button.
• Three dot menu: Click to reveal additional options.
  • Edit: Click to edit the configuration settings.
  • Duplicate: Click to create a new connection for a different Division or reuse the connection with different settings.
  • Delete: Click to permanently delete the connection. Confirm on the pop-up.
  

You can access your configuration settings at any time by clicking the Configuration button in the Dashboard. Please refer to the Dashboard section for more information.

Dashboard

The SharePoint dashboard shows you an overview of actions happening with your assets.

At first glance, the Metrics tab shows stats about the total number of files currently synced to SharePoint, the last successful sync, and the last failed sync.

The chart below demonstrates how many assets were created, updated, and deleted by the sync in a given timeframe. Change the date ranges to compare data and group by month, week, day, or hour.

In the Events tab, you’ll find an overview of assets synced to SharePoint with more granular details related to the sync, such as status, operation, timestamps, external ID, and failure reason.

You can search for a specific asset, filter by date range, or sort the results as needed.

You can also search for failed events with a particular reason for failure. Please check the dropdown menu to see all possible failure scenarios within your integration.

Property Reference Table

Here is a list of all available properties and types of columns available between Showpad and SharePoint to reference as needed:

User Permissions

You can enable non-admin users to set up the integration by either:

• delegating permissions to them in SharePoint
• consenting to the integration on behalf of the organization in Showpad

Delegate Permissions

Because the Microsoft Entra ID can be configured in multiple ways, the instructions in this section will demonstrate the process in SharePoint Online.

1. Within SharePoint Online, from the menu on the top left, select Admin.
2. This opens the Microsoft 365 admin center. In the left side menu, click Show All to expand the section and select Identity.
3. This opens the Microsoft Entra admin center. In the left side menu, expand the Applications section, select Enterprise applications, and then click Consent and permissions in the Security section.
4. Select Admin consent settings from the left side menu. Enable the options to allow non-admin users to create a consent request when connecting via the Next-Generation SharePoint connector:
   • Users can request admin consent to apps they are unable to consent to
   • Selected users will receive email notifications for requests
   • Selected users will receive request expiration reminders

   With these settings enabled, non-admin users will see the following message when connecting via the Next-Generation SharePoint connector:

   They will have to wait until their admin approves the request. Admins can find and process these requests on the Admin consent requests page within the Microsoft Entra admin center. In the left side menu, expand Applications, and select Enterprise application. From the Activity section of the left menu, select Admin consent requests.

   Once the admin approves the request, non-admin users can use their user account to connect to the SharePoint sites they have access to.

Consent for Organization

If you decide not to enable non-admin users to consent to third-party apps in SharePoint, they will see the following message when attempting to connect:

You can set up the integration so non-admin users can connect by:

1. Follow the steps to Install the SharePoint app and authorize the integration.
2. On step 5 in the Connect to SharePoint section, select the Connect with delegated permissions option.
3. Log in as a qualified admin and check the box to Consent on behalf of your organization.
4. Click Accept.
5. At this point, you can exit the connection setup, and a non-admin user can make the connection. Because an admin has already given organization consent, any other user can now successfully connect to SharePoint.