Move files from a SharePoint site to Azure File Storage

Question

Move files from a SharePoint site to Azure File Storage

Arthur Wart 0

Hi all

My client is continuously hitting its SharePoint storage limit. Since additional SharePoint storage is expensive, they have an Azure Files storage that they use to archive the files of SharePoint sites that they no longer use, but of which they still want to retain the data.

Their current procedure to archive and copy data from a SharePoint site to Azure File storage is the following:

Synchronize SharePoint site data to local PC > Copy folders and files from local PC to Azure Files > Delete the SharePoint site

Client wants a faster and easier way to archive their SharePoint sites to Azure File storage. With big sites it sometimes is a hassle to sync all the files and copy it to Azure Files.

I found a few articles describing a way with PowerAutomate to copy files to Azure Blob Storage and then copy to Azure Files. However these articles only offer a way to copy new files uploaded to the SharePoint site to Azure Files. I want to copy all files of a certain SharePoint site at any given moment to Azure Files.

Does anybody have an idea how to achieve this? With or without PowerAutomate?

2 answers

Your answer

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Dillon Silzer 57,831 Volunteer Moderator

Have you taken a look into Azure Data Factor capabilities?

Copy data from SharePoint Online List by using Azure Data Factory or Azure Synapse Analytics

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory

Copy file from SharePoint Online

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online

You can also look at the following solution for connection Azure Files to SPO:

HOW TO CONNECT AZURE FILE STORAGE WITH SHAREPOINT

https://www.layer2solutions.com/how-to-connect/azure-file-storage

If this is helpful please accept answer.

Arthur Wart 0 Reputation points

2023-10-10T06:41:38.67+00:00

Thanks for your answer. I think I will have to use third party migration software to perform this operation (like your third option). Seems like the best way to retain folder structure and data migration.
Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2023-10-11T01:59:54.5766667+00:00

Hi @Arthur Wart ,

I'm glad you found a solution that works for you and would like to thank Dillon Silzer for his contribution.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2023-10-20T08:17:01.22+00:00

Hi @Arthur Wart ,

I am checking the status of this case. Please let us know if you would like further assistance.
If you have any update about this issue, please feel free to post back.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Share via

Move files from a SharePoint site to Azure File Storage

2 answers

Your answer