FTP to OneDrive

[DarinSpence]

My client's vendor insists on sending me files via SFTP.  Does anyone have a lightweight tool or method for receiving files via SFTP and putting them into Onedrive?

[Naitanabmors]

Use CloudMounter to connect to the SFTP server and mount it as a drive. That how I solved such issue earlier.

[ImkeF]

Hi @Rabihb ,
the file needs to be in the main folder.
Each sub-folder would need it's own trigger.
If that's not working, consider changing the trigger to the one I used (...properties only).

[ImkeF]

You can use a flow in Power Automate for it: FTP server to OneDrive for Business | Microsoft Power Automate

I'm using it to transfer from FTP to Azure Blob storage and it works like a charm.

[Rabihb]

I am trying to accomplish the same task but I'm not being able to trigger the flow.

I did exactly the same flow in the link.

I added a new file to my ftp server hoping it would trigger, but it didn't.

What might be the problem?

[alexia101]

hey,

Please can you tell me how you are connecting FTP to blob. Do you have excel files that you download from FTP?

[ImkeF]

yes, I'm moving csv-files from ftp to Azure blob. But this can be any other file type as well: 

[DarinSpence]

I don't have an FTP server.  It looks like I'm going to have to setup an FTP server to receive files from the client, then use the Power Automate routine you've suggested. 

Anyone have any slick tools, methods or services that can recieve file via FTP?  I can setup an FTP server.  I'm just trying to avoid having 'one more thing' to monitor/manage.