Unanswered

Copy file from SharePoint 2013 to online using on-premises data gateway in power automate

(1) Share

Report

Posted on by neenadani

I need to copy files along with folders from SharePoint 201 to online. For this, created a on-premises data gateway connection. Used "Get files (properties only)" action in power automate (with the connection of on-premise SharePoint site. Site address and library are given). Then used "Apply to each" action to loop through files and folders. In this action "items('Apply_to_each')?['{Path}']" is empty. Hence unable to get the file content and create file under the folder path. Need to maintain the folder structure.

Suggestions please!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi @neenadani ,

Here's some framework for you to consider and I think it will achieve what you are looking for. The key here, as you described, is you must maintain folder structure and you can do that with a conditional step. If the folder exists, you are simply creating files.

If the folder doesn't exist, you are creating the folder and files, if the folder exists, you only create the folders.

Was this reply helpful? Yes No
neenadani 4 on at

Like (0)

Report

Thank you much for the reply!
After getting file properties using the action "Get files (properties only)" from on-premise SharePoint site library. In the loop, "items('Apply_to_each')?['{Path}']" is empty. Not getting the folder path. This is the issue.

Was this reply helpful? Yes No