cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

SFTP Trigger Ignoring New Files with Old Modified Dates

When I upload old files from my local machine to the SFTP server, the Modified Date for each file is preserved, not updated, on the SFTP server.  These files are ignored by the SFTP trigger "When Files Are Added of Modified" and are not copied to SharePoint the way fresher files are.

 

I need every file I drop on the SFTP server to relaibly replicate to the SharePoint library.  What am I missing?

 

Nick

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
New Member

Re: SFTP Trigger Ignoring New Files with Old Modified Dates

Hi, Alice.  Thank you for responding. 

 

A different approach resolved my issue:  rather than detecting the file by date in my trigger, I added an Interval trigger, set to e.g. Daily, and then used an SFTP - List Files action after to act on all files in the SFTP folder.  After the List action, we use a SharePoint - Create File action, and finally an SFTP - Delete File action.

 

This solution was provided to me by Microsoft Flow Support.  Very elegant.  Now, the only remaining question is, when I use this method to copy 6000 55 KB PDFs from SFTP to SPO, the rate is only 8 files per minutes, under Flow Plan 2 trial -- is that rate the best we can expect?

 

Nick

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: SFTP Trigger Ignoring New Files with Old Modified Dates

Hi @ npettijohn,

 

 

 Could you please share a screenshot of the configuration of your flow?Do you mean the flow with trigger When a file is added or modified wouldnt run when you add a new file with old modified dates in the SFTP server? Please share more details about your scenario, so we could try to help you.

 

 

Regards,
Alice Zhang

Highlighted
New Member

Re: SFTP Trigger Ignoring New Files with Old Modified Dates

Hi, Alice.  Thank you for responding. 

 

A different approach resolved my issue:  rather than detecting the file by date in my trigger, I added an Interval trigger, set to e.g. Daily, and then used an SFTP - List Files action after to act on all files in the SFTP folder.  After the List action, we use a SharePoint - Create File action, and finally an SFTP - Delete File action.

 

This solution was provided to me by Microsoft Flow Support.  Very elegant.  Now, the only remaining question is, when I use this method to copy 6000 55 KB PDFs from SFTP to SPO, the rate is only 8 files per minutes, under Flow Plan 2 trial -- is that rate the best we can expect?

 

Nick

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (13,978)