Add Microsoft List to Azure Data Factory

Yu-Wei Nicolas Tang 116 Reputation points
2021-01-20T15:32:42.977+00:00

Hi, I am trying to use Microsoft List and Azure Data Factory together. I know that MS List is build on Sharepoint List and Sharepoint List has a connector to ADF but I can figure out where to find all the required field for MS List ![58722-image.png][1] Where can I find the URL, Service Principal ID and the key? I'm using the new MS List, I don't have any Sharepoint running. [1]: /api/attachments/58722-image.png?platform=QnA

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,808 questions
{count} votes

Accepted answer
  1. Saurabh Sharma 23,816 Reputation points Microsoft Employee
    2021-01-22T01:29:43.567+00:00

    anonymous user I do not think it is supported if you store it under "My Lists". If, however, you store the list under SharePoint site during creation it will work with the steps documented on the official documentation over here.
    I have validated in my local environment and it works fine. Here is the list which I have created on SharePoint using Microsoft List and stored under my SharePoint not under "My List".
    59402-image.png

    I can access the same list in SharePointList Dataset which I have later moved to Blob Storage.
    59391-image.png

    Storage Snapshot
    59403-image.png

    However, I am checking internally with the products team if creating list in your personal using Microsoft List is supported or not and I will get back to you on the same ?

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Yu-Wei Nicolas Tang 116 Reputation points
    2021-01-22T10:50:59.373+00:00

    It's amazing, this is exactly what I needed ! Thank you !


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.