Import multiple files stored in Sharepoint at one time

[dot101]

Hello,

As shown in the image below, I have several Excel files stored in the Sharepoint site, my goal is to import all the files and later stack them into one dataset, is this possible? How, please.
There are too many files that I can't import individually, and every week two files are added, so I want to automate this.

Thanks for any help.

[AlexT · Accepted solution]

Hi,

You can do this with Files from Folder dataset.

Create a folder with the Sharepoint location where these files are added. Then create a "Files from the folder" dataset. +Dataset - Internal - Files from Folder. Go to the advanced option once you select the folder and then use regex/glob to match you file pattern. 

Now if you use this dataset every time you build your flow it will read all files that match this pattern including new files that were added. 

Let me know if this works for you!

[dot101]

Hi Alex, this is what I was looking for, thanks a lot!