web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Split excel file to mu...

Power Automate

Answered

Split excel file to multiple csv files based on column value

(0) Share

Report

Report

Posted on by Maniu

8

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:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Verified answer

v-chengfen-msft on at

Like (0)

Report

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

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 on at

Like (0)

Report

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
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

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

Join the conversation