Hello,
I have multiple excel files in SharePoint, each file contains a table with identical column headers. I want to consolidate these files into a single table in a separate workbook. I have created the workbook which will be used to merge the data and saved it to SharePoint.
I have no idea where to start to create the flow in Power Automate, please can anybody help?
Thanks!
Elaine