SharePoint File Archive Automation

[threw001]

Hello,

I have an existing flow that saves a file into a SharePoint Shared Documents. The Structure goes:

/Shared Documents/XYZ Folder/

The file is then saved in the 'XYZ' Folder

I have another folder within XYZ Folder, called 'Archive', I would like to archive the only excel file in /Shared Documents/XYZ Folder/ into Shared Documents/XYZ Folder/Archive.

When building this flow, what I have found is that due to the directory, the flow attempts to move all existing files in 'Archive' to 'Archive' again and it fails. Is there anyway to specifically only move the file that is in  /Shared Documents/XYZ Folder/, without touching the ones in the 'Archive' folder contained within 'XYZ Folder' 

This flow will be part of a daily flow, so everyday I will look to move the excel file in /Shared Documents/XYZ Folder/ into Shared Documents/XYZ Folder/Archive, and the flow will continue to save a brand new file in /Shared Documents/XYZ Folder/

Thanks

[Rhiassuring]

So someone is dropping one file a day - an xlsx - and you want to move it into the subfolder, archive, daily. 

And it sounds like right now you're telling it to move all items - or are you? Can we see a screenshot of your flow in Edit mode?

There's lots of ways to do it - you could filter by xlsx, sort by newest, and only take the first one, for example. 

Is the Excel file always named the same way? 

[threw001]

Hi thanks for your help

Yes - I actually have a flow that drops an excel file daily into /Shared Documents/XYZ Folder/. What I currently do is manually move the file from the prior day into  /Shared Documents/XYZ Folder/Archive. The file name differs every day as the file name is date/time stamped.

I have messed around with the flow so much it currently doesn't even work 😔

Please see screen shot of flow

FYI the flow I have that creates and drops the file in the directory  is a separate flow

[Rhiassuring · Accepted solution]

Try this out - 

This is saying:

"only show me files that are Excel files"

"show me the most recently added one first"

"do not look in subfolders"

"only give me 1 back"

This should do what you want, if they're dropping in an Excel file to be moved to Archive once a day.

[threw001]

This worked perfectly!!! Thank you so much 🙂

Just a sidequestion.. maybe more of a sharepoint  question but thought I would ask just in case you have any experience...

The file that I am moving, multiple people are accessing within the organisation. I am going to have the flow run really late or early hours in the morning so hopefully no one is using or is in the file when the flow to move it activates. In the case some one leaves their laptop on and they are still in the file, the file locks and cannot be moved due to someone being in the file. (just got this error whilst testing just now because someone is actually using the file). Is there anyway around this?

[Rhiassuring]

The work-around would be to have check-in/out turned on, and then to force a check-in before moving ... but...  your users might not like that, because if they've got it checked out and are offline, they lose their work (or they can re-upload it later.) 

[threw001]

Is there anyway to include this within the flow above?

I am happy discarding any work if the user is offline/does not save before this flow runs

Thanks so much again

[Rhiassuring]

Well, first, do you know if check-in / out is turned on in the library?

[IS11]

Can you please share the step by step instructions? My case is I will be having daily excel uploads. So, I want to archive the previous day version into an archive folder in the same root folder and just have the recent ones directly in root folder as that is the path being used in Power BI to fetch the file data.

[IS11]

If I have 3 files being uploaded daily and want to auto archive the older versions for each one of those, how to achieve that? This logic just archives the most recently uploaded files among the list