Unanswered

Microsoft Flow - File System error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Team,

Can anyone help me with setting up my flow properly? I need to create a flow wherein I can automatically download an excel file from a sharepoint site and save it to my local within a certain schedule (e.g. Every monday I want the excel file in sharepoint to be automatically downloaded in my local storage.

I have created a flow right now using a manual trigger (I have not set up the scheduling part yet), but I am having issues with the saving of the excel file.

My flow goes like this:

Manual trigger > Initialize variable (for file name increment) > Get file content (sharepoint) > Create file (file system) > Increment variable

Once I get to the create file action, I get an error saying that my credentials are not valid. I am not sure why as I believe I have setup my connection properly.

file system error.png flow screenshot.png

See connection screenshot here. I even have the gateway already installed:

connection 1 of 2.png connection 2 of 2.png

When I run the test and input a directory in the folder path, I get an error saying this:

"The credentials for this connection do not have access to 'C:/Users/acalma2/Desktop/Forms_1', please try using a different location or account.\r\nclientRequestId: 2d1c2c27-7576-446a-aa57-a2351242b1d8"

I am absolutely sure about my credentials, I even tried it multiple times but it still is not working from my end. Can anyone please help me? I need this urgently.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

Brad_Groux 4,556 on at

Like (0)

Report
Copy link

Link copied!

Have you ever gotten the On-Premise Gateway to work? If not, you should review the Understand on-premises data gateways for Microsoft Flow documentation, specifically the Configure a firewall or proxy (proxy details) and Configure ports sections. Also, note that installing the gateway on a domain controller is not supported.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please follow this document to recreate the connection to File system then test it again:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-using-file-connector

The Root folder should be configured to something likes below:

\\PublicShare\\DropboxFiles

I have made a test likes below which is working well.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your reply, but I still am not able to make it work. Can you help me more?

I tried the root folder thing, but it still is getting the forbidden error (403). I am absolutely sure I am using the correct credentials for my own machine, so I am not sure what's the problem. I have also setup the gateway fine, the root folder and the file path too. Can you please look at the screenshots below and see if you can help me? Clearly, I have been stuck with this problem and I need to finish this ASAP.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not understanding this. Can you walk me through this?

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

When creating the connection, please go to Properties>Sharing to get the Path of the folder.

Hope this will work for you.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel,

Thank you for your reply. Is this applicable also for folders that are not shared? I just want to have a flow wherein it can make an automation where a file from sharepoint will be automatically downloaded in my local storage, specifically, my documents folder. I checked my documents folder and I don't have the network path. Is my goal even possible? Or it will only work in a shared folder?

Regards,
Aaron

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Per my certain tests, it seems that it only works for a Shared folder.

When testing with a not shared folder, I got the same error message with you.

Please take a try with a shared folder. I suppose it will work for you.

Best regards,

Mabel

Was this reply helpful? Yes No