FAQ: Access SharePoint site collections (subsites) in a flow

A SharePoint site collection is made up of one top-level site and the subsites below it. You must create a connection to SharePoint or create an HTTP connection to SharePoint before you can access a subsite. After creating the connection, you can move on to creating your integration.

You can create an export in two ways:

• Create an HTTP export with your HTTP connection to SharePoint
  • No additional requirements
• Create a SharePoint export using your SharePoint connection
  • This requires you to change the Form View to REST API

In your export, add your relative URI relative to your SharePoint base URI. The typical value of this field is the resource path portion of an API endpoint. Some examples are: /product or /bulkUpdate/orders. This relative URI value is combined with the base URI defined in the connection resource associated with this export. The base URI and relative URI complete a fully qualified URL describing an API endpoint.

To access a subsite, add the subsite name in front of your relative URI. For example, /SubSite/_api/web/lists/GetByTitle('Test").

You can create an import using the SharePoint application:

• Create a SharePoint import using your SharePoint connection
  • This requires you to change the Form View to REST API.

In your import, add your relative URI relative to your SharePoint base URI. To access a subsite, add the subsite name in front of your relative URI. For example, /AssistantTeam/_api/web/lists.

Create an import and export for SharePoint subsites