cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dylanv
New Member

Splitting Excel File According to Multiple Variables

Hello everyone,

 

I have a data set in Excel that I want to split according to multiple variables. I started off by looking at another forum post on how to split an Excel file based on single variable.

 

dylanv_0-1621520301503.png

 

I've been using the data that the user for this post was using, just as a test set so that I can later implement the flow with my own data. I've also created my flow in the same way as the user that solved problem did. 

 

dylanv_1-1621520635430.png

dylanv_2-1621520669596.png

 

This flow is successful at separating the data into three Excel files, categorized by the "Location" value. However, I now want to separate the data according to multiple variables. Say, I would like to pull only data that contains the location "Los Angeles" and the item "Notebooks" and only extract those rows into the file "Los Angeles-Notebooks.xls". Another file would be
Los Angeles-Paperclips.xls", which would contain only Los Angeles paperclip data. Is there any way to do this? Thank you!

0 REPLIES 0

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (2,038)