Event based copy from SharePoint

Question

Event based copy from SharePoint

Kumaresan K 31

Kindly help me out in resolving below scenario

how to make an event-based trigger in #AzureDataFactory to fetch data from SharePoint.. Whenever file gets modified or new files got placed in SharePoint, ADF needs to trigger a pipeline on event-based. Kindly assist

LUCAS MASCARENHAS ALMEIDA 0 Reputation points

2023-03-27T14:03:22.4733333+00:00

Any news about it? It would be handy, nowadays the ADF is able to create pipelines to get data from SharePoint, but to create an event-based trigger we have to use the Azure Logic Apps yet.

Accepted answer

1 additional answer

Your answer

LUCAS MASCARENHAS ALMEIDA 0 Reputation points

2023-03-27T14:03:22.4733333+00:00

Any news about it? It would be handy, nowadays the ADF is able to create pipelines to get data from SharePoint, but to create an event-based trigger we have to use the Azure Logic Apps yet.

Answer 1

PRADEEPCHEEKATLA 90,651 Moderator

Hello @Kumaresan K ,

Welcome to the Microsoft Q&A platform.

Unfortunately, you cannot use event based trigger a pipeline on creation of a file from SharePoint.

Note: The Event Trigger currently supports only Azure Data Lake Storage Gen2 and General-purpose version 2 storage accounts.

For more details, refer “Create a trigger that runs a pipeline in response to an event”.

I would suggest you to provide feedback on the same:

https://feedback.azure.com/forums/270578-data-factory

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Kumaresan K 31 Reputation points

2021-06-02T11:25:01.163+00:00

Thanks for your help.. is there any workaround to do that??
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2021-06-03T09:43:18.21+00:00

Hello @Kumaresan K ,

One possible way is using logic apps to automate this workflow.

Using Share point connector in logic app – monitor files or items created and trigger logic app execution.

And, using Azure data factory connector – create pipeline run Action.

To Know more about Share point connector in logic app check below link:

https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sharepoint

To Know more about Azure Data Factory connector check below link:

https://learn.microsoft.com/en-us/connectors/azuredatafactory/

Hope this helps. Do let us know if you any further queries.

Answer 2

I dont believe the accepted answer is correct.

While An event within sharepoint cannot trigger a pipeline in Azure. Adding a file from Sharepoint can trigger a process to copy a file to Azure Storage. An event from Azure storage can then be used to trigger your pipeline.

https://learn.microsoft.com/en-us/answers/questions/898508/copy-files-from-sharepoint-to-azure-blob-storage-u

https://powerautomate.microsoft.com/en-us/templates/details/9f3013836eb64243a04306a0133d25eb/copy-files-from-a-sharepoint-folder-to-a-azureblob-folder/

Share via

Event based copy from SharePoint

1 additional answer

Your answer