Creating Office 365 SharePoint Custom Connectors on Microsoft Flow

Updated: Mar 29, 2019

Here, let us look how the custom connectors can be created for accessing SharePoint data on Microsoft Flow.

Microsoft Flow provides multiple connectors from various services including SharePoint to work with the data. The connectors contain multiple triggers and actions. For SharePoint connector by Out of the Box, Microsoft provides 8 triggers and 28 actions on Microsoft flow.

UseCase: Imagine you want to retrieve the SharePoint user profile data of some user. Currently there is no action available for MS Flow developers to retrieve SharePoint user profile data. Such triggers and actions can be created by developers on the Microsoft Flow platform. In this post, let us look how one such custom action can be created and used on the Microsoft Flow platform.

The configuration involves the following steps.

  1. Configuring Azure AD Application, which provides necessary permissions and helps in authenticating the calls made from Microsoft Flow.

  2. Generating the collection file (Swagger) using postman tool, which will be used as base file while building the custom connector.

  3. Configuring the custom connector, which will make call to SharePoint to get the required data with necessary inputs.

  4. Testing the custom connector created above.

  5. Creating/Configuring the flow, which will also use the custom connector we have created above.

Configure Azure AD Application for Flow Authentications:

  • Create a new app on the Azure Active directory.

  • Go to keys under settings, and create a new password value and store the same. The password needs to be pasted on the Microsoft Flow portal.

  • Select Required Permissions under API Access and select necessary permissions for accessing SharePoint user profile data. The following snapshot shows the permissions selected.

  • Reply URL needs to be updated once you configure the custom connector security details.

Generate the Collection File for Custom Connector: