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
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,940)