Azure Data factory Support with Sharepoint (Target)

Question

Azure Data factory Support with Sharepoint (Target)

Saisandeep Kamalraj - External 0

We have a requirement to push files into microsoft sharepoint. Does Azure Data Factory has a connector to perform this operation using copy data Activity?

1 answer

Your answer

Answer 1

Nandan Hegde 35,021 MVP

Unfortunately ADF doesn't support rest api or SharePoint library as a sink.you would have to use logic app or azure function or some other offering to achieve it

phemanth 15,320 Reputation points Microsoft External Staff

2025-03-24T07:45:29.8433333+00:00
Adding to above answer

Here’s how you can use Logic Apps to upload files to SharePoint:

Create a Logic App: In the Azure portal, create a new Logic App.

Add a Trigger: Choose a trigger that starts the workflow, such as a scheduled time or an event in another service

Add Actions: Use the SharePoint connector to add actions that interact with SharePoint. For example, you can use the "Create file" action to upload files to a SharePoint document library.

Configure Actions: Set up the necessary parameters for the actions, such as the SharePoint site URL, document library, file content, and file name.

For detailed steps Logic Apps connectors documentation

Azure Functions

Azure Functions is a serverless compute service that allows you to run event-driven code without having to manage infrastructure. Here’s how you can use Azure Functions to upload files to SharePoint:

Create an Azure Function App: In the Azure portal, create a new Function App.

Create a Function: Add a new function with an HTTP trigger.

Write Code: Implement the function to use the SharePoint REST API for uploading files. You can write the code in C#, JavaScript, or other supported languages.

Deploy and Test: Deploy the function and test it by sending HTTP requests to upload files.

For more details Azure Functions with SharePoint REST API documentation

Hope this helps. Do let us know if you any further queries.
Ganesh Gurram 6,280 Reputation points Microsoft External Staff

2025-03-25T10:36:04.2533333+00:00

Saisandeep Kamalraj - External

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Azure Data factory Support with Sharepoint (Target)

1 answer

Your answer