Answered

SFTP trigger only fired with freshly modified files

(0) Share

Report

Posted on by atte

130

Hello, i have a SFTP-SSH Trigger/When Files Are Added Or Modified in my flow. In connection i use password, not SSH key. Action is to create file in OneDrive.

It works fine when:

1) A file is edited in SFTP-folder

2) When a freshly modified file is added to SFTP-folder

It does not work when:

3) An old file (not recently modified) is added to SFTP-folder

No errors. The trigger just doesn't fire. Even if i modify a file in SFTP-folder, the old-dated-files are ignored. I have also tried to re-create the connection in the flow (instead of using existing connection) but the same thing.

- What can be set wrong?

Categories:

Using connectors

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

v-sefedo Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

According to the connector limitations, trigger will work only if file modification date was updated. Seems like modification date of an old file is preserved so trigger skips that file.

Please review your SFTP client settings and disable "preserve timestamp" option, I believe that should do the trick.

Was this reply helpful? Yes No
atte 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the quick response, that explains. In the old Power Automate SFTP-trigger there was no such of limitation, but seems that old trigger is no more available for the new flows?
- How can i disable "preserve timestamp" option in Power Automate? I can not find a direct option either in the Flow or in the Connector.

Was this reply helpful? Yes No
v-sefedo Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That option should be disabled in SFTP client app (Filezilla/WinSCP/etc), that's not a Power Automate setting.

Was this reply helpful? Yes No
atte 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, so there is no way to get around this with M365 Power Automate SFTP-Connector to on prem sftp-server?

Was this reply helpful? Yes No
v-sefedo Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The problem here is that file modification date is preserved, so the trigger considers a file with an old date as already processed. How do you add a file into SFTP folder? It is manual process using some SFTP client or some process automatically publishing these files?

Was this reply helpful? Yes No
atte 130 on at

Like
a
(1)

Report
Copy link

Link copied!

It's customer's business program adding the files, so not sure what is doable there. Need to figure out some workaround. Thank you @v-sefedo anyway for the support, that saved me from further testing and trying.

Was this reply helpful? Yes No
visheshvats1 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, were you able to find and implement a workaround to your problem?
Thanks

Was this reply helpful? Yes No
atte 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, yes i did.
After saving the file (by our desktop program) we let the program to update file timestamp and then the Flow recognises it as a new file. For example:
System.IO.File.SetLastWriteTime(<your filepath>, DateTime.Now)

Was this reply helpful? Yes No