How i Download File from sharepoint using Power Automate

Question

I want to download a Zip File through Sharepoint using Power Automate Desktop or Cloud tell me a way i can do this process

---

Moved from Microsoft 365 and Office | SharePoint | Development

Answer 1

To download a file from SharePoint using Power Automate, you can follow these steps depending on whether you are using Power Automate Desktop or Power Automate Cloud:

Power Automate Cloud:

1. Create a new flow: Start by creating a new flow in Power Automate.
2. Add a SharePoint action: Search for the SharePoint connector and select the action to download a file. You may want to use the Get file content action.
3. Specify the Site Address: Choose the SharePoint site where your file is located.
4. Select the File Identifier: You can either specify the file path or use dynamic content to select the file you want to download.
5. Use the file content: Once you have the file content, you can use it in subsequent actions, such as saving it to OneDrive or sending it via email.

Power Automate Desktop:

1. Launch Power Automate Desktop: Open the application and create a new desktop flow.
2. Add the SharePoint connector: Use the SharePoint actions available in Power Automate Desktop to interact with your SharePoint files.
3. Download the file: Use the appropriate action to download the file from SharePoint to your local machine.

Make sure you have the necessary permissions to access the SharePoint site and the file you want to download.

Answer 2

Hello @Rakshit Kumar,  

Thank you for reaching out to the Q&A forum! 

To support you better, please confirm this point: 

Do you want to download the file: to your local desktop or to OneDrive? 

Currently, I can only test Power Automate in a web environment, so I’ve tried creating a flow to download the ZIP file from SharePoint to OneDrive first.  

Here are the steps you can refer to: 

• You can go to Power Automate => Create => select “Instant cloud flow”. After you name the flow, you can select trigger “Manually trigger a flow" 

 

• After that, you will see the screen where you can start creating the flow. Please click Create to proceed:

1.Add SharePoint Action- Get file content: 

• Action: you find and select “Get file content” 

 

• Site Address: You can copy and paste your SharePoint site.  
• File Identifier: Choose the ZIP file from the document library. 

 2.Add OneDrive Action – Create file: 

• Action: you can choose “Create file” in OneDrive 

 

• Folder Path: You select a folder in OneDrive (for example, in my test, I chose Desktop folder). 

 

• File Name: you can name “file.zip” 
• File Content: please use the output from Get file content. 

• After that, you can save the flow and click Run to test it. 

In my test, I was able to see the ZIP file in the selected folder on my OneDrive, just as I described in the steps above. 

If you want to download the file to your local machine, please reply and let me know. 

Also, I’d like to reconfirm: are you using a personal account (Hotmail/Outlook.com) or a work/school account? 

Looking forward to hearing from you. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.