Hello Vaibhav Patil,
I just work in a similar use case , so let me share with you some insights:
- You can start deciding between create an script(code) or drag and drop automation tool (low code) to achieve main task:
- a) Download file from sharepoint
- b) Upload to Storage account
- About using the coding option, you can use an azure function with powershell and time trigger execution to complete both task a and b. Here some guides:
- https://learn.microsoft.com/en-us/azure/azure-functions/functions-reference-powershell?tabs=portal
- https://learn.microsoft.com/en-us/azure/azure-functions/create-first-function-vs-code-powershell
- https://learn.microsoft.com/en-us/answers/questions/788342/powershell-script-to-download-specific-folders-fro
- https://learn.microsoft.com/en-us/azure/storage/blobs/storage-quickstart-blobs-powershell
- About using the low code option you can use for example logic apps / Power apps also using a time trigger function , take on consideration that for complex configuration even with low code solution you need to go to the code (json) to make some modifications.
- https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-azureblobstorage?tabs=consumption
- https://learn.microsoft.com/en-us/azure/connectors/connectors-native-recurrence?tabs=consumption
- https://caiomsouza.medium.com/using-azure-logicapp-to-pull-files-from-microsoft-sharepoint-559dceb905c4
I hope this information help you to address your challenge .
If the information helped address your question, please Accept the answer.
Luis