All,
I have a flow that is creating an excel file in our SharePoint site. The files are created and named by the Employee's ID.
So in our SharePoint site we have multiple files named
- Employee123.csv
- Employee345.csv
- Employee678.csv
I would like to create a flow that takes all these excel files and combines all the data into another excel file. The columns are all the same so the format should not be an issue. The combined file can also export in the same SharePoint link.
Any suggestions how to approach?
Thanks