So I like to use an Azure Files (from an Azure Storage Account) that mounts to hybrid workers with an Azure Automation account to do SFTP transfers. But I need a way for internal users to be able to add files without giving them access to my storage account. In this example, we create a one drive folder on a service account and share it with different groups in the organization. We then have a Logic App that will go and copy each of the files to Azure Files on the storage account and then delete them from OneDrive. We can then create an Azure Runbook (Azure Automation) to go and transfer the files to a third party service.
Source code is here
Be sure to find/replace for
double open bracketsto set your own values. Also keep in mind I had to make many changes to sanitize it so it is just a general idea of how the Logic App will work, you might have to tweak it.
What makes this Logic App especially useful is that you have an array of folder names, and for each of them you loop through and move the files to the storage account!