SOLVED

Flow for moving files based on file age

%3CLINGO-SUB%20id%3D%22lingo-sub-223582%22%20slang%3D%22en-US%22%3EFlow%20for%20moving%20files%20based%20on%20file%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-223582%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20business%20need%20in%20having%20meeting%20files%20on%20a%20SharePoint%20document%20library%20folder%20move%20to%20another%20folder%20on%20the%20same%20document%20library%20after%207%20days%20of%20the%20original%20files%20being%20uploaded.%20A%20custom%20workflow%20I%20believe%20SharePoint%20Designer%20was%20created%20for%20this%20several%20years%20ago.%26nbsp%3B%20Now%20that%20we%20are%20looking%20at%20moving%20the%20site%20to%20SharePoint%20Online%20we%20wanted%20in%20leveraging%20Microsoft%20Flow.%26nbsp%3B%20Has%20anyone%20come%20across%20a%20template%2Ftrigger%20(maybe%20is%20missed%20it%20when%20searching%20whats%20available)%20where%20you%20can%20specify%20as%20the%20condition%20the%20age%20of%20the%20document%20(upload%2Fcreation%20date)%20so%20that%20the%20file%20is%20them%20moved%20to%20the%20archive%20folder%3F%20Thank%20you%20for%20any%20advice%2Finsights.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-223582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-234599%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20for%20moving%20files%20based%20on%20file%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-234599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18815%22%20target%3D%22_blank%22%3E%40Juan%20M%20Baena%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EAn%20alternative%20method%20might%20be%20to%20use%20the%20%22When%20a%20File%20is%20Created%22%20trigger%2C%20and%20then%20a%20%22Delay%20Until%22%20action%20set%20to%207%20days%20-%20and%20then%20proceed%20with%20the%20%22Move%22%20steps.%20In%20that%20case%2C%20you%20wouldn't%20need%20to%20add%20a%20column%20to%20check%20for%20a%20past%20date%20once%20a%20week%20-%20each%20file%20would%20trigger%20a%20Flow%20when%20the%20file%20was%20uploaded%2C%20and%20wait%20in%20the%20background%20for%20a%20week%20before%20proceeding.%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Sandy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-224071%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20for%20moving%20files%20based%20on%20file%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224071%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20for%20the%20response%20and%20reference%2C%20taking%20a%20look%20and%20for%20testing%20this%20approach%20again%20thanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-223621%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20for%20moving%20files%20based%20on%20file%20age%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-223621%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20looks%20like%20what%20you're%20looking%20to%20do.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fjoannecklein.com%2F2018%2F01%2F02%2Fa-modern-transfer-to-another-location-in-office-365%2F%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjoannecklein.com%2F2018%2F01%2F02%2Fa-modern-transfer-to-another-location-in-office-365%2F%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Good Day

 

We have a business need in having meeting files on a SharePoint document library folder move to another folder on the same document library after 7 days of the original files being uploaded. A custom workflow I believe SharePoint Designer was created for this several years ago.  Now that we are looking at moving the site to SharePoint Online we wanted in leveraging Microsoft Flow.  Has anyone come across a template/trigger (maybe is missed it when searching whats available) where you can specify as the condition the age of the document (upload/creation date) so that the file is them moved to the archive folder? Thank you for any advice/insights.

3 Replies
best response confirmed by Juan Carlos González Martín (MVP)

Thank you so much for the response and reference, taking a look and for testing this approach again thanks,

Hi @Juan M Baena,

An alternative method might be to use the "When a File is Created" trigger, and then a "Delay Until" action set to 7 days - and then proceed with the "Move" steps. In that case, you wouldn't need to add a column to check for a past date once a week - each file would trigger a Flow when the file was uploaded, and wait in the background for a week before proceeding. 

- Sandy