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.
Click Save & Test. Fivetran will take it from here and sync your data from your lists.