Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Save to local PC from sharepoint - File system / On premises Gateaway Connection

(0) ShareShare
ReportReport
Posted on by

Hello all,

I am trying to create a flow to download a file from sharepont to my pc. I am using these steps to do it: 

First have installed my on premises gateway, then created a connection using it. 

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install 

When I create the flow and add the "Create file" (File System), I try to search for the Folder Path setup in my connection but can't find it, i get this error below  (so I add the connection folder path manually)

File system flow1.PNG

 

My entire flow looks like this:  (Folder path in the File System step is added manually, typed in)

File system flow.PNG

When I run the flow, first 2 steps are OK, I get on the last step with  this message: 

"message": "The credentials for this connection do not have access to 'c:/my file connection path_/Desired file from sharepoint.xlsx', please try using a different location or account.\r\nclientRequestId: e5592fa6-9e01-4277-a274-d21c6588e61d"
 
Is it from my connection ?  
Thanks
 
 
 
  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Save to local PC from sharepoint - File system / On premises Gateaway Connection

    Hi @Anonymous ,

     

    You could just select the file through the file browser to select a specific file.

     

    Best regards,

    Mabel

     

     

  • Re: Save to local PC from sharepoint - File system / On premises Gateaway Connection

    Hi Mabel,

    File System works and connects now, thank you, there was an error with the auth. 

     

    If on that sharepoint folde, I have several files uploaded on daily basis in the same location, how can I tell my flow to only download a specific .xlsx only, called "Daily Report" ? 

     

    Thank you,

    Mihnea 

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Save to local PC from sharepoint - File system / On premises Gateaway Connection

    Hi @Anonymous ,

     

    Have you created a connection to File system connector successfully?

     

    Once we created the connection, we can select the folder from the file browser. From your screenshot, I guess you entered the folder path manually. Am I right?

     

    About how to create a connection to file system, please check the following doc:

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

     

    Further, in the action Get file content, are you going to get the file which triggered the flow? If so, you could use dynamic content Identifier from the trigger.

     

    From the screenshot, it seems that you are getting file content from a specific file.

     

    I have made the following test for your scenario, which is working properly.

    1.PNG

     

    Best regards,

    Mabel  

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics