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

Split one Excel into multiple workbooks

It is easy to combine multiple Excel workbooks and append data. 

How can I take this single workbook and split it into separate workbooks based on data in a given column and then send out an email?

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @mkappeyne :

Do you want to divide the data in the excel table into multiple workbooks based on a certain column, and then send this excel file to someone by email?

If so,please try this flow:

1\My excel file

1.JPG

2\Whole flow

4.JPG

3\Detail

FireShot Capture 008 - Edit your flow - Power Automate - asia.flow.microsoft.com.png

Referencr Expression:

a\Apply to each-Select an output from previous steps

union(body('Select'),body('Select'))

b\Compose-Inputs

items('Apply_to_each')?['Email']

c\FIlter Array

items('Apply_to_each')?['Email']

The Result:

2.JPG3.JPG7.JPG

Best Regards,

Bof

 

mkappeyne
New Member

Thanks for the suggestion. I will be trying it out in the next days. 

Happy Holidays. 

Thanks for the help. I am still very new to Flows/Power Automate. Could you provide clearer screen shots of the different steps you used?  The ones I received are too fuzzy to try to replicate. 

Many thanks and Happy New Year.

v-bofeng-msft
Community Support
Community Support

Hi @mkappeyne :

Sorry, because the picture is too big, the details are not clear when displayed on the webpage. I suggest you download the picture, after downloading it you can zoom in at will.

1.JPG

Best Regards,

Bof

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (50,827)