How to use IBM App Connect with Microsoft SharePoint

Microsoft SharePoint is a collaborative platform which provides document management and storage system capabilities. IBM App Connect works with SharePoint Online (cloud-based service) and SharePoint Software (SharePoint Server on premises).

Availability:
  • A connector in IBM App Connect on IBM CloudCloud-managed connector
  • A local connector in a Designer instance of IBM App Connect in containers (Continuous Delivery release)Local connector in containers (Continuous Delivery release)
  • A local connector in a Designer instance of IBM App Connect in containers (Extended Update Support)Local connector in containers (Extended User Support release)
  • A local connector in a Designer instance of IBM App Connect in containers (Long Term Support)Local connector in containers (Long Term Support release)
The following information describes how to use IBM® App Connect to connect Microsoft SharePoint to your other applications.

What should I consider first?

Before you use App Connect Designer with Microsoft SharePoint, take note of the following considerations:

  • To authenticate connection to SharePoint Online using SAML verification, IBM App Connect does not support two-factor authentication. Before using IBM App Connect with your Sharepoint account, check if your account has two-factor authentication enabled and, if so, disable two-factor authentication.
  • The SharePoint connector cannot be used to access personal site collections. To work with personal site collections, you can use the Microsoft OneDrive for Business connector.

Connecting to Microsoft SharePoint

For the considerations and steps you need to connect App Connect on IBM Cloud to a Microsoft SharePoint account, see Connecting to Microsoft SharePoint from IBM App Connect on IBM Cloud.

Tip:

Before you use the account that is created in App Connect in a flow, rename the account to something meaningful that helps you to identify it. To rename the account on the Catalog page, select the account, open its options menu (⋮), then click Rename Account.

After creating a new Microsoft SharePoint connection account in IBM App Connect Designer, you can see the available events to trigger a flow by clicking Show configurable events… under the account on the Catalog tab. You can also see the available Microsoft SharePoint actions.

General considerations

Before you use App Connect Designer with Microsoft SharePoint, take note of the following general considerations:

  • (General consideration) You can see lists of the trigger events and actions that are available on the Catalog page of the App Connect Designer.

    For some applications, the events and actions in the catalog depend on the environment (IBM Cloud Pak for Integration or App Connect on IBM Cloud) and whether the connector supports configurable events and dynamic discovery of actions. If the application supports configurable events, you see a Show more configurable events link under the events list. If the application supports dynamic discovery of actions, you see a Show more link under the actions list.

  • (General consideration) If you are using multiple accounts for an application, the set of fields that is displayed when you select an action for that application can vary for different accounts. In the flow editor, some applications always provide a curated set of static fields for an action. Other applications use dynamic discovery to retrieve the set of fields that are configured on the instance that you are connected to. For example, if you have two accounts for two instances of an application, the first account might use settings that are ready for immediate use. However, the second account might be configured with extra custom fields.

Events and actions

Microsoft SharePoint events

These events are for changes in this application that trigger a flow to start performing the actions in the flow.

Show configurable events... Events shown by default are pre-configured using optimized connectivity. More items are available when you have configured events that can trigger a flow by polling this application for new or updated objects. For more information about configurable events, see Configuring polled events to trigger flows.

Microsoft SharePoint actions

These are actions on this application that you want a flow to complete.

Files
Retrieve all files
Create file
Download file
Retrieve files
Rename file
Delete file
Update file
Folder item
Retrieve folder items
Folders
Retrieve all folders
Create folder
Retrieve folders
Delete folder
Update folder
List item attachments
Retrieve all list item attachments
Create list item attachment
Download list item attachment
Retrieve list item attachments
Delete list item attachment
Update list item attachment
List items
Retrieve all list items
Create list item
Retrieve list items
Delete list item
Update list item
Lists
Retrieve all lists
Create list
Retrieve lists
Delete list
Update list
Sites
Retrieve all sites
Create site
Retrieve sites
Delete site
Update site
User
Retrieve Users

Examples

Screenshot of the dashboard tile for a template that uses Sharepoint

Use templates to quickly create flows for Microsoft SharePoint

Learn how to use App Connect templates to quickly create flows that perform actions on Microsoft SharePoint; for example, open the Templates gallery then search for sharepoint.

Learn more

Screenshot of the dashboard tile for a template that uses Sharepoint

Creating an event-driven flow that creates a site in Eventbrite online, adds a list to the site, and then posts a message in Slack

Learn how to use App Connect to connect Eventbrite to Microsoft SharePoint and Slack so that when a new event is created in Eventbrite, App Connect automatically creates a site in Microsoft SharePoint online, adds a list to the site, and then posts a message in Slack.

Learn more