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?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

v-bofeng-msft on at

Like (2)

Report
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
AdamBOT 2 on at

Like (0)

Report

Thanks for the screen shots. However can you please provide the screen shot of create table?

Was this reply helpful? Yes No
stringer57 3 on at

Like (0)

Report

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

Was this reply helpful? Yes No
sheepmaster 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sabrinaklf 4 on at

Like (0)

Report

Hi, did you get an answer? I am stuck here...
thanks alot

Was this reply helpful? Yes No
Ctzani 5 on at

Like (1)

Report

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!

Was this reply helpful? Yes No