cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stefjaro
New Member

Flow to regroup excel spreadsheets into zip files based on file name

Hi Community,

 

I've 2.500 excel spreadsheets located in a shared drive.  Spreadhseet name has the same structure, like:

 

ClientA_report_Product1.xlsx
ClientA_report_Product2.xlsx
ClientA_report_Product3.xlsx
ClientA_report_Product4.xlsx
ClientA_report_Product5.xlsx
ClientA_report_Product6.xlsx
ClientA_report_Product7.xlsx
…...xlsx
ClientB_report_Product1 
ClientB_report_Product2.xlsx
ClientB_report_Product3.xlsx
ClientB_report_Product4.xlsx
ClientB_report_Product5.xlsx
ClientB_report_Product6.xlsx
ClientB_report_Product7.xlsx
….. 
ClientZ_report_Product255.xlsx

 

I would need to combine those files into 30 zip files: 1 zip file that contains all reports by client . Like this:

ClientA_report.zip
ClientB_report.zip
ClientC_report.zip
…...zip
ClientZ_report.zip

 

Any idea how can I combine the files using power automate flow?

Thanks in advance

 

stefan

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,281)