SFTP File Transfer from Sharepoint - Successful! - But not really.

[MrLiquidBread]

I've setup a flow to transfer (or Copy) the files contained within a Sharepoint folder and transfer them via SFTP on a site that's hosted on Google Cloud Services.

After finally getting over the "Bad Gateway" hurdle that I see many people have with the SFTP-SSH connector, I thought I had this flow working.  (Creating the private/public keys in .pem format fixed my issue.) 

When I run the flow, it reports back as "Successful" and no errors showing in the Flow Checker.  

However, if I fire up WinSCP and connect to the SFTP server to verify that file has indeed been transfered, I can see the folder is still empty.  So even though Power Automate is telling me everything worked as it should, the file never got transfered.  I've included my flow below, but can anyone shed any light on how I can better troubleshoot this flow when it apparently says it worked?

[MrLiquidBread]

I've gotten this far, but again, it's not really showing me much in terms of troubleshooting.  It appears that the last step "Apply to each" isn't running as it's greyed out, or maybe running but without any data to apply to?  Looking at the raw inputs and Outputs of the "Get Files (properties only" step, I really don't know what I should be looking for, or if there's information missing.

[v-xiaochen-msft]

Hi @MrLiquidBread ,

The action 'Get files(properties only)' returns empty values.

In other words, you don't have any files from this SharePoint library folder.

Please check that if you have entered the correct site or folder path.

Best Regards,

Wearsky

[MrLiquidBread]

Hi @v-xiaochen-msft ,

I have checked that path several times, but the "Get files (properties only)" was entered by simply following the prompts and navigating/drilling down to my Sharepoint folder during the step build , not by manually entering the path by hand.

As you can see in the capture below, I have two .csv files sitting in this folder and I have no idea why the "Get Files..." step is returning a null value.  Both files contain data and they're essentially the same file.  In an attempt to troubleshoot this further, I copied the original test file and removed the underscores from its name, which I wouldn't think would cause a problem.  But at this point I'm blindly throwing darts at this issue because the flow looks to have been built correctly and I have no idea why it's not working as intended.

[MrLiquidBread · Accepted solution]

Hi @v-xiaochen-msft ,

I was poking around in the Sharepoint document library when I saw this message at the top of the library settings page.  I'm guessing this is what's causing the "Get Files..." to return a null value.  

I'm going to try and use the "When a file is created (properties only)"  and see if that works since it won't be dealing with a list.  If that doesn't work, I'll try using a different document library that hasn't hit this threshold.

[MrLiquidBread]

Hi @v-xiaochen-msft ,

That was indeed the issue.  I create a new document library to be used only for this file transfer and applied my flow to it.  Manually running the flow transferred the file within 10s and using WinSCP I can see the transferred file sitting on the SFTP site.  

Chris