Unanswered

Flow for Saved excel file on SharePoint to Mapped drive

(0) Share

Report

Posted on by Gurchetan

Hello, really new to power automate. A quick direction will help.

I am trying to get the saved excel file on SharePoint to my company's mapped network drive.

The Excel file is being modified by several people on daily basis wondering a flow can be setup to get the existing file and likewise modified changes to network drive automatically.

I read we need on on-premise data gateway, which I believe we have already setup, I can see while trying to set the flow.

Thanks

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ArchitectMadhan 1,584 on at

Like (1)

Report
Copy link

Link copied!

Hi @Gurchetan ,

As you have mentioned the On-Premise gateway has been configured, your next step would be to create an automated flow that would trigger "When a file is created in SharePoint" (you can use other trigger option like modified). In the flow trigger you need to configure the SharePoint document library path, and then add file system action to configure the destination path (Mapped Drive). For more details, please refer the below link.

https://knowledge-junction.com/2021/12/23/power-automate-on-premises-gateway-copying-file-from-sharepoint-document-library-folder-to-local-pc-folder-network-drive-folder/

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

Like (0)

Report
Copy link

Link copied!

Thanks 🙂

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

Like (0)

Report
Copy link

Link copied!

Thanks Madhan, it helped me a lot. I have small question, the link you shared shows when a file is created in a folder, in my scenario the file is already there and contains multiple worksheets in it. I am only interested in getting two worksheets and whenever somebody update those two worksheets it automatically overwrite and reflect the same on mapped drive copied excel file.

Therefore, should I be creating a new file in the File system and by using Create File action? As currently that two worksheets I am interested in already has 4k+ rows content in them.

Thanks

Was this reply helpful? Yes No