Whats the best way to go about creating new excel sheets based on one sheets specific ID?

Like (0) Share

Report

Posted on 5 Aug 2021 13:32:29 by Community Power Pla...

Essentially we have 1 raw data sheet with all departments information. Each department has an unique ID. I want to use Power Automate to parse the excel data, so that is separates the departments data, and then puts that data in a new excel sheet for each department.

The idea I have thought of was creating an empty array and populating it with the rows that match a certain ID. Then using that array to repopulate a new empty worksheet. If that makes sense...

I'm just not sure if there is an easier way to go about it.

All responses (1)

Answers (0)

GeoffRen Microsoft Employee on 06 Aug 2021 at 19:22:35

Like (1)

Report

Re: Whats the best way to go about creating new excel sheets based on one sheets specific ID?

That way would work, but only if your data is in a table. Most ExcelOnline Business actions only work with table formatted data. If your data exists just in raw ranges, Office Scripts (specifically Office Scripts with Power Automate) is your only option. This is the 'Run Script' action on the Excel connector. With Office Scripts you can use the 'Run Script' action to execute javascript against a workbook. This option would also be easier if you know javascript and could actually be less lines of code than number of Flow steps!