Microsoft Lists Setup Guide

Follow our setup guide to connect Microsoft Lists to Fivetran.

Prerequisites

To connect Microsoft Lists to Fivetran, you need:

A SharePoint account
A SharePoint Site containing lists
The ability to grant Fivetran permission to read from this account
The SharePoint account used for authorizing the connection, needs read-access to the top-level SharePoint site or Hub site

In the connection setup form, enter the Destination schema name of your choice.
Click Authorize. You will be redirected to your SharePoint account to authorize Fivetran's access. Once you have finished, you will be redirected back to Fivetran.
Use the Use Input Field for Site toggle to choose how you want to specify the SharePoint site:
- If the toggle is set to ON, a text input field appears, allowing you to manually enter the site using the format {hostname},{siteCollectionId},{siteId}.
- If the toggle is set to OFF, use the Sync Lists from Site drop-down menu to select the SharePoint site from the available list.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.
Click Save & Test. Fivetran will take it from here and sync your data from your lists.