Hi team,
PowerAutomate newbie here!
In Excel, I have column names "Starting Invoice Number" and "End Invoice Number", the range is 999. I'm trying to write a flow that converts this into new rows where the range is 50 in each row. I want to be able to bring across the other columns that are in the table as they are. The initial table will have rows added to it and want the flow to occur on this instance.
Example of initial data
BusinessEntityTax ID |
InvoiceCategoryCode |
InvoiceCategory |
InvoicePeriod |
InvoicePrefixName |
StartingInvoiceNumber |
EndingInvoiceNumber |
3 |
7 |
A |
Jan-24 |
A |
54623050 |
54624049 |
3 |
7 |
A |
Feb-24 |
B |
54623050 |
54624049 |
3 |
7 |
A |
Mar-24 |
C |
54623050 |
54624049 |
3 |
7 |
A |
Apr-24 |
D |
54623050 |
54624049 |
So it should turn into this:
InvoicePeriod |
InvoicePrefixName |
StartingInvoiceNumber |
EndingInvoiceNumber |
Jan-24 |
A |
54623050 |
54623099 |
Jan-24 |
A |
54623100 |
54623149 |
Jan-24 |
A |
54623150 |
54623199 |
Jan-24 |
A |
54623200 |
54623249 |
Jan-24 |
A |
54623250 |
54623299 |
Jan-24 |
A |
54623300 |
54623349 |
I then want to be able to separate the range of 50 into individual rows in another table.
Attached is the example of the first flow I've tried to build.
Help would be greatly appreciated!