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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

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 Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (4,240)