Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaySet up your SharePoint list connection
This article outlines the steps to create a SharePoint list connection.
The SharePoint list connector supports the following authentication types for copy and Dataflow Gen2 respectively.
| Authentication type | Copy | Dataflow Gen2 |
|---|---|---|
| Anonymous | n/a | √ |
| Windows | n/a | √ |
Data Factory in Microsoft Fabric uses Power Query connectors to connect Dataflow Gen2 to a SharePoint list. The following links provide the specific Power Query connector information you need to connect to a SharePoint list in Dataflow Gen2:
- To get started using the SharePoint list connector in Dataflow Gen2, go to Get data from Data Factory in Microsoft Fabric.
- To determine the URL to use to access your SharePoint list, go to Determine the site URL.
- To connect to the SharePoint list connector from Power Query, go to Connect to a SharePoint list from Power Query Online.
In some cases, the Power Query connector article might include advanced options, troubleshooting, known issues and limitations, and other information that could also prove useful.
Data Factory in Microsoft Fabric doesn't currently support a SharePoint list in data pipelines.
Additional resources
Training
Module
Integrate Power Automate with SharePoint HTTP actions - Training
Interact directly with SharePoint data using the REST service in Microsoft Power Automate flows.
Certification
Microsoft Certified: Power Platform Fundamentals - Certifications
Demonstrate the business value and product capabilities of Microsoft Power Platform, such as Power Apps, data connections with Dataverse, and Power Automate.