Move data from Sharepoint sites to blob using Logic app

Question

How can i read all the files, folders and data from Sharepoint site and load it in to Azure Blob container using Logic Apps. What all pre requisite and permissions are required.

Answer 1

Hello @Merugu, Hemant - Thanks for reaching out, and engaging us on the MS Q&A community.

I answered a similar question on the following thread: Migrate Data from Sharepoint to ADLS using Logic Apps

Below is an example implementation for migrating all subfolders and any files on SharePoint to the ADSL gen2 storage account:

Some considerations:

• Sharepoint connector -> Get Files (properties only) action was chosen for returning the list of folders and files instead of other actions such as List Folders because it returns all of the folders & files in a one-dimensional array of objects that each contain useful details like Full Path including filename and extension, and the folders are flagged with {isFolder}: true property. As such, no recursive traversal operation is needed.
• Using the details, fetch the content of each file and recreate them in ADSL gen2 using the Create blob (V2) action. Because "Full Path" is used for the "Blob name", folder structure will be automatically created, and can be navigated using Data Explorer.
• Be sure to review Concurrency control and Sequential run settings to fine-tune performance & scale.
• I tested with simple Request/Response and migrated 86 small files successfully without a timeout occurring on the Response. However, for a larger number of files that entail longer running work, HTTP may not be great. You can add any trigger of your choice to the above, and perhaps, add an action at the end to send an email notifying that the job is completed.

Could you review the above thoroughly and see if the steps help you get started? Feel free to tag me in the comments below if you have any follow-up questions

---

Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.