Sharepoint to Azure Blob Storage

Question

Hello,

I have looked at the solutions for syncing files between Sharepoint and Azure Blob and all of them suggest using a logic app or power automate. The issue is both of these solutions have a limit on the size of the file that gets copied. How do I copy large files between the two.

Answer 1

To transfer large files from SharePoint to Azure Blob Storage, there are several methods you can consider, as outlined in Microsoft's documentation:

1. You can use Microsoft Power Automate: You can use Power Automate for copying files from a SharePoint folder to an Azure Blob folder, though this might have limitations:

• File Size Limitations: Power Automate has a maximum file size limit for individual files. This limit can vary based on the plan you are using, but typically, it's around 100 MB to 250 MB per file. This makes it unsuitable for transferring very large files.
• Throughput and Performance: The performance of Power Automate can be influenced by network speed and the overall service load. For large volumes of data or very large files, the transfer speed might not be optimal, leading to longer transfer times.

If your files are larger than 250 MB you might consider using other options, like Azure Storage Mover, or can use Date pipelines, or scripted transfer with Azure Automation Account, Maybe Data Box! Id really depends. Maybe you can share more info ? Like;

1. Do you want to programmatically, and periodically move your files from SharePoint to your Blob storage ?
2. How large is your file/s?