Unanswered

Split one Excel into multiple workbooks

(0) Share

Report

Posted on by Community Power Pla...

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?

All responses (9)

Answers (0)

Ctzani 5 on at

Like (1)

Report

Re: Split one Excel into multiple workbooks

Thanks for the solution.

Is it possible to provide us the details for the step create table? I am loosing what we should fill in "table range" and "table name: fields. Million thanks!
Sabrinaklf 4 on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

Hi, did you get an answer? I am stuck here...
thanks alot
sheepmaster 2 on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

hi @v-bofeng-msft
in the "Create Table" action the table range field is filled with?
stringer57 3 on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

Is it possible you can share this in larger format, so I can read all exact flows?
AdamBOT 2 on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

Thanks for the screen shots. However can you please provide the screen shot of create table?
v-bofeng-msft on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

Hi @Anonymous :

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.

Best Regards,

Bof
Community Power Pla... on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

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.
Community Power Pla... on at

Like (0)

Report

Re: Split one Excel into multiple workbooks

Thanks for the suggestion. I will be trying it out in the next days.
Happy Holidays.
v-bofeng-msft on at

Like (2)

Report
Re: Split one Excel into multiple workbooks

Hi @Anonymous :

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

2\Whole flow

3\Detail

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:

Best Regards,

Bof