Compile multiple Excel files into one

[aishak12]

All, 

I have a flow that is collecting PowerApps data and exporting it into an excel file that is located in a internal SharePoint site for each user.

Now I have a SharePoint account with full permission, So I would like to merge all the data from these files into one excel file in another SharePoint location. 

Is this possible? 

Thanks 

[v-qiaqi-msft]

Hi @aishak12,

Do you want to merge multi excel files into single one excel file?

Could you please share a bit more about your scenario?

If you want to merge multi files into single one excel file, I am afraid that there is no out-of-the-box trigger or action can monitor multiple files in one flow.

As an alternative solution, I think the Power Query could help you solve this issue:

Combine Data From Multiple Excel Files into a Single Excel File - With Dynamic Columns and Sheets - ...