Error on Copy SharePoint Files to folder

[joxner]

I have a Flow where it copies the entire contents of a SharePoint folder to another SharePoint folder.

The files successfully copy over except each time it runs I get an error on the Copy file stage of the flow.  

[rzaneti]

Hi @joxner ,

It looks like your file was not found in the Copy file action. Can you share your inputs from this action?

[joxner]

Hello,

Please see attached.  

Get FolderList FolderFor EachConditionCopy File

[rzaneti]

Hi @joxner ,

Thank you for sharing it. The error is happening because you are using the "Id" property in the "Copy file" action, while you should be using "Path" from "List folder":

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 
https://www.linkedin.com/in/raphael-haus-zaneti/ 

[joxner]

Hello,

I changed it to Path under the Copy File action. And it copied over the files and folders. But I still got an error. 

[rzaneti]

Hi @joxner ,

Cold you please share the error message?

[joxner]

Hello,

I am receiving the following error or Outputs on the Copy File action. It performed the action 8 times. One was a success. The other seven produced the same error.

{
"statusCode": 404,
"headers": {
"Cache-Control": "max-age=0, private",
"Vary": "Origin",
"X-NetworkStatistics": "0,525568,0,0,5769,0,26774",
"X-SharePointHealthScore": "3",
"X-MS-SPConnector": "1",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "21",
"SPRequestDuration": "22",
"X-DataBoundary": "NONE",
"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"SPRequestGuid": "126b7d0f-3f3d-4ab6-80ee-b5cca50ca5f9",
"request-id": "126b7d0f-3f3d-4ab6-80ee-b5cca50ca5f9",
"MS-CV": "D31rEj0/tkqA7rXMpQyl+Q.0",
"Strict-Transport-Security": "max-age=31536000",
"X-Frame-Options": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.office365.com *.powerapps.com *.yammer.com engage.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
"MicrosoftSharePointTeamServices": "16.0.0.24817",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Mon, 06 May 2024 17:56:36 GMT",
"Content-Length": "168",
"Content-Type": "application/json",
"Expires": "Sun, 21 Apr 2024 17:56:36 GMT",
"Last-Modified": "Mon, 06 May 2024 17:56:36 GMT"
},
"body": {
"status": 404,
"message": "File not found\r\nclientRequestId: 126b7d0f-3f3d-4ab6-80ee-b5cca50ca5f9\r\nserviceRequestId: 126b7d0f-3f3d-4ab6-80ee-b5cca50ca5f9"
}
}

[rzaneti]

Hi @joxner ,

Reviewing the images that you shared, it seems that you are saving the file with a predetermined name in the destination folder, which matches to the dynamic content one of the properties from your Excel action. I don't know what is the expected content from this property, so it is also possible that you are saving it in a subfolder rather than a file. 

I have 2 recommendations here: 

1. If it makes sense for your use case, consider to remove the Excel dynamic content from the "Destination Folder" in your "Copy file" action. 

2. In your "Copy file" action, try to change the "If Another File Is Already There" from "Fail" to " Copy with a new name":

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 
https://www.linkedin.com/in/raphael-haus-zaneti/ 

[joxner]

Hello, thank you for the reply!  I tried changing it to "Copy File with New Name" but still got the error. All of the files and folders still copied over.

The Excel sheet gathers where the files should be saved under a folder. There is nothing in the folder when the files are being copied over.  For example, the files are being placed in Documents/Non-profits/ABC Inc/ or Documents/Non-profits/Bob Food Bank/.  Where the trigger goes and gets the company name and folder path and then the template folders to copy over.  Further, there are five different types of sample folders to copy from. The Excel sheet tells the Flow what files to copy over from within one of the sample folders.  Then those folders and files (between 6-12 files and folders) are copied into the client's folder. So, Documents/Non-profits/ABC Inc/  would have Documents/Non-profits/ABC Inc/Formation, Documents/Non-profits/ABC Inc/notes.docx, Documents/Non-profits/ABC Inc/Originals etc.  

Hope this helps. And thank you for taking the time to assist!

[rzaneti]

Hi @joxner ,

So far, I don't know exactly what could be causing the problem. You mentioned that all of the files/folders were copied over: is the error still happening in the "Copy file" action, or is it happening in a further step?

If the error is still happening in the "Copy file" action, I recommend you to navigate until the failed loop iteration (you can simply click in "Next failed" in your "Apply to each"), and confirm if the inputs for source/destination folders look correct, as eventually the dynamic content from Excel can be adding an extra slash or blank space in the path.