Split excel file to multiple csv files based on column value

(0) Share

Report

Posted on by Maniu

Hi,

I have already tried multiple solutions found on forum but none works for me.

I have an excel file one OneDrive that contains following table:

Item	Value
1	1
1	2
1	3
2	1
2	2
2	3

I would like to create a flow that filters the table for each Item and saves it as new file named Item.

Desired output would look like this:

File name: "1"

Item	Value
1	1
1	2
1	3

File name: "2"

Item	Value
2	1
2	2
2	3

Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Maniu ,
I made a template for your reference
Here is excel:

Here is flow：
Take out the "Item" column with Select.
and then Union will get the "Item" array to remove duplication by deduplication

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Maniu 8 on at

Like (0)

Report
Copy link

Link copied!

Well, thank you for your fast response.

I did as you wrote, saved the flow, and try to run it but I get that it is unsuccessful.

Here is re-created template I did. (edit: changed to ENG)

And here's result:

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Maniu ,
Can you provide a screenshot of your error message?

This can effectively guide the location of the problem.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
From looking at the screenshots, it looks like it might be due to no space in the Filter Query between eq and the single quote.
eq' //should be eq '

Was this reply helpful? Yes No
Maniu 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you for help!

@v-chengfen-msft:
There wasn't any error message except status - failed on the flow screen:

@grantjenkins:
I was able to figure that out after checking the flow another time and it didn't help.

However, today in the morning I just pressed run and it worked.

Was this reply helpful? Yes No