Unanswered

Help needed to create a flow to download files based on paths defined in a column in an excel file in SharePoint

(0) Share

Report

Posted on by Iam_asking

Hi,

I have an Excel file in a folder in SharePoint. The file includes a table that has several file paths defined in a column. I want to create a flow to loop through each row in the file path column and download the files to a specific folder.

I have tried every possible action and have yet to find anything on this topic.

Thanks in Advance!

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

File paths - are these file paths also pointing to SharePoint? When you say download, do you mean Move, or do you mean Copy?

Was this reply helpful? Yes No
Iam_asking 4 on at

Like (0)

Report
Copy link

Link copied!

1) Yes, the paths are Pointing to a Sharepoint
2) Yes, i need to Copy

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

So if it's all within one site, it'll look like this (you can ignore that mine says it's pointing at OneDrive - it's the same process)

My "File" in Excel shows /library/folder/folder/filename.ext -- for example, /Expenses/December/Invoice2345.pdf

If your files were all from different sites, aka http://1234.sharepoint.com/sites/abc/expenses... and http://1234.sharepoint.com/sites/123/expenses you'd need to break out the site and put that into the "site address" as dynamic content instead.

Then I just hard coded the site & folder that I want to copy to, and used the "path" from the "get the file metadata using path" output.

Was this reply helpful? Yes No
Iam_asking 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you for guiding me on this. For some reason, I am getting a flow time-out error. I shall try with a different SharePoint and check.

Was this reply helpful? Yes No