cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aishak12
Helper IV
Helper IV

Compile multiple Excel files into one

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 

1 REPLY 1
v-qiaqi-msft
Community Support
Community Support

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 - ...

Best Regards,
Qi

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,084)