Copy folder structure and move files to new location within SharePoint

[ChrisLong]

Hi All,

I am trying to create a flow to do the following:

Search through a large SharePoint document library (100k+ items) for files which have not been modified in 3 years. 

If the flow locates a file which matches the condition, this file needs to be moved to an archive library which is on the same site.

The file must keep the same folder structure when moved into the archive library.

I.e Library 1/Customer 1/Folder 1/File.docx -moves to-> Archive Library/Customer 1/Folder 1/File.docx

The folder structure would not be deleted from the source location as there may be other files still there that do not meet the condition yet.

----------------------------------------------------------------

I have setup the flow so it creates when the condition is met, it will create a .txt file in the archive location which creates all the folders needed.

I then simply need to move the file into the new archive location that the file has created. 

My flow is currently constantly failing on the moving of the file.

The error message I get is: 

{

  "status": 400,

  "message": "Failed to verify the existence of destination location at '[SiteName]/Archive Library/Test Library/Customer 1/' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.\r\nclientRequestId: ac62b0c3-c33e-43f6-8f83-3836d33d691d\r\nserviceRequestId: ac62b0c3-c33e-43f6-8f83-3836d33d691d"

}

However the folder does exist in that location (with the .txt file that created it)

Any help on the issue or how I can improve the flow is appreciated 

[Mira_Ghaly]

@ChrisLong

On your copy step destination parameter try to use the same as the one you used to create the folder and not the variable.

[ChrisLong]

Hi @Mira_Ghaly 

Thanks for the quick reply. 

unfortunately this is still getting the same error

{

  "status": 400,

  "message": "Failed to verify the existence of destination location at '[Sitename]/Archive Library/Test Library/Customer 1/' due to error 'The system cannot find the file specified. (Exception from HRESULT: 0x80070002)'.\r\nclientRequestId: 49057ba5-5c31-4bd1-adc1-fc8f53f86268\r\nserviceRequestId: 49057ba5-5c31-4bd1-adc1-fc8f53f86268"

}

[ChrisLong · Accepted solution]

I managed to find the solution to this.

After the folders were created by the create file, I used a get folder metadata with path step then passed the Path into the move file step.

Hope this helps anyone else with a similar issue.

[James_Harriman]

Hi Chris,

Very new to flows and i was wanting to know if there is any chance of getting a full look at each step in the Flow?

I am trying to setup the same thing for a couple of my customers.

I can get a flow to move all files from one Library to an Archive Library if they are older than 3 years but it does not copy the folder structure which makes it kind of pointless.

Regards,

James

[kaybran1]

Hello Chris,

I am looking to implement the same process and cannot wrap my head around the first part where you are creating the .txt file to build the Folder structure. Would you mind expanding on that concept?

[JCSik]

@ChrisLong I'd also appreciate if you could post the full code of all your steps for this, as I need to do the exact same thing as you have done. 

[KeerthiRaj96]

Hi Chris,

I am new to MS Flow creation. Currently, I am working on the exact same requirement which is need for our customers as you mentioned in this post. My flow works fine where folder structure is followed and copied, but again it is returning the items of subfolders in the library a recursive way (it is returning items many sub folders deep).

It will be helpful if you could share the complete flow along with the code which will help me to complete the same and analyze the issue caused in my flow. Appreciate your quick response.

[Anonymous]

I know this is old, but is it possible for you to post up the details of all your flow steps?  

I'm trying to do the exact task you were, and I'm getting hung up on how you setup the variables...thanks so much!!

[gijsprins93]

Hey Chris,

I need to do the same thing exactly, but as the others here pretty new to PA. Do you have some more detail of your flow? 

[Clay4s]

Hi Chris, this is awesome but do you have a template or instructions for this flow, this is what ive been looking for. Awesome Archive solution @ChrisLong 

[Clay4s]

Did you get the steps and got it working

[Anonymous]

Could be cool if you would share the whole flow to us mortals 🙂

[Adouke-1]

Hello,

Can you share the details? I need to do same and I am sruggling.

Many thanks, Manuela