web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Moving files from onpr...
Power Automate
Unanswered

Moving files from onprem to sharepoint with folder structure

(0) ShareShare
ReportReport
Posted on by 31

Hi 

 

I'm creating a flow for copying files from onprem folder to sharepoint site, using the onprem data gateway.

 

But i want to keep the folder structure, so each file in put in the right directory as in the onprem, i've made a complete copy of the structure in sharepoint, so only new or modified files will be uploaded.

 

How would i go about making sure the files gets copied to the right folder in sharepoint

 

kwkn1910_0-1685004938979.png

 

see attached flow

 

thanks in advance

Categories:
I have the same question (0)
  • Unknown geen idee Profile Picture
    1,757 on at

    Dear K,

     

    I am not entirely sure on the actions/details available regarding the onpremises files, but would expect there would be some action by which you can get the path of the files. For example something like:

    • /onpremiselocation/folder123/folderABC/filesomething.doc

    This is basically your solution template. 

    Once you take a file, try to copy it to the sharepoint with exactly that path .... but the start of the path is replace with the sharepoint root. For example something like:

    • /sharepoint/documents/folder123/folderABC/filesomething.doc

    You can build in some checks/conditions to create relevant folders in advance or on the fly.

    I am sure you get the idea.

     

    Hope the suggestion helps,

    Happy flowing,

    Koen

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard