I am trying to use the File System - Copy File action to move a file from SharePoint to an On-Premises File System. Maybe some of you have seen a similar issue.
In the failure summary, I can see the details of the issue. It tells me that the provided credentials don't have access to the target path. This looks suspect to me - why does it switch the direction of the slashes before the file name?
The outputs file is showing the following errors:
The local On-Premises Data Gatewaty logs showed this error:
Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The credentials provided for the Folder source are invalid.
I've troubleshot this (so far) by:
Has anyone encountered issues similar to this?
In Flow, when working with File System actions, you need to create a connector to your On-Premises Data Gateway. Here is the screen.
In the fields for Username and Passowrd, you have to put the credentials in the domain\login pattern. I was failing when I entered the credentials as firstname.lastname@example.org. After recreating the connection using these credentials, I was able to connect using the On-Premises Data Gateway.
Also - you can use the PowerShell command below to return the logged on domain and user:
After making this change, I was able to use the File System - Create File action successfully, but not the File System - Copy File action.
Could you please share a screenshot of your flow’s configuration?
The issue is confirmed on my side. I think the File System connector have no access to the file in SharePoint with “Link to item” content. Only the people who are assigned with proper access could access the file in SharePoint.
Besides, if you want to copy file from SharePoint to local folder, please take a try with the alternative way as below:The flow works successfully as below:
I had the same Forbidden error and this solution worked for new files saved to the folder or e.g. right click -> New - Text Document, but failed for files pasted into the folder.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.