web

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

Power Platform CommunityForums Power Automate - Building Flows Need to split my excel...

Power Automate - Building Flows

Unanswered

Need to split my excel in to multiple based on Column Values

(0) Share

Report

Report

Posted on by Community Power Pla...

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

Desired Output is Each Business unit in Separate excel with the BU name. Please someone Guide to achieve the Result.

Note- Am new to Power Automate please explain in detail

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

schwibach Moderator on at

Like (0)

Report

Re: Need to split my excel in to multiple based on Column Values

I think you should use power automate to transfer the data to a SharePoint list and then create excel files for each business unit and a power query that gets the filtered data from Excel.

I think that would be a better workflow than trying to create individual Excel files with Power Automate.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 560 Super User 2025 Season 2

#2

Tomac 347 Moderator

#3

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans