Unanswered

Get and merge excel files from different sharepoint libraries

(0) Share

Report

Posted on by NewUser22

Hi folks,

I have around 30-50 libraries that have MS form results in excel and i would like to check if there is a way to dynamically populate the path to retrieve the files? I don't think i will be able to configure each library one by one.

Thinking to have a main source - file path for the 30-50 libraries and dynamically get the files.

Would that be possible? After getting the files from different libraries, we would like to merge those files into a single file.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Paulie78 8,422 Moderator on at

Like (0)

Report

I think it would be much easier to use Power Query in Excel to do this.

You can easily combine multiple Excel files into one.

Was this reply helpful? Yes No
NewUser22 69 on at

Like (0)

Report

Thanks, I think the main issue is that they are all form results from different sharepoint libraries. Can power query merge data from multiple sharepoint libraries?

Was this reply helpful? Yes No