Power Platform Community Forum Thread Details

For the answer to ur question, try the below approach

For answering your question, i had made a sample excel file having 2 column : ID, Country

Excel file used for demo: Data.xlsx

Using the above file Data.xlsx, I had build a flow which spilt the Data.xlsx file data into sub files considering the ID column as unique value

Flow screenshot

Flow Part 1Flow Part 2Flow Part 3

Logic behind this flow:

1. First step is to read the master excel file, here Data.xlsx, for that i had used launch excel and then read the excel using Read from worksheet

Here the %FirstFreeColumn - 1% & %FirstFreeRow - 1% are taken using the action get first free row/column action

[see that in main flow screenshot]

2. After reading the excel file and storing in a variable, next step is to retrive the unique ID column value , this is done by using 2 steps, first retriving the column values as list and then removing the duplicates as shown in below screenshots

Next Step is to loop through each unique value in the list which has the id values, for that we are using for each loop

within the for each loop, we are doing the below sub steps:

a. Launch an excel opening a blank document [ for the new excel which we are going to create for storing the respective ID data]

b. Adding headers to new excel using write to cells [ the master excel sheet headers]

c. Setting a integer variable i with value as 2 [ this is done writing values to cells in new excel document]

d. Next is , we are looping through each row in master excel sheet and and then checking if the first column value is equal to the unique value from list in the current iteration using if action, if so then use write to cell action for writing the data to new sheet and then increasing the i value by 1