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.
See connection screenshot here. I even have the gateway already installed:
When I run the test and input a directory in the folder path, I get an error saying this:
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
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
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
Hi,
I am not understanding this. Can you walk me through this?
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.
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
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!