Unanswered

Take a comma separated list and apply to separate rows in excel

(0) Share

Report

Posted on by adam0s

Hello,

I am building an order and warranty tracking system and have a step that takes a quantity entered on an order form and adds that # of rows to an order log in excel, I am hoping there is also a way to take a list of comma separated tracking #'s from that same form and add one # to the tracking # column in each of the newly created rows.

Here is a screenshot of this step (this is replicated for each item on the form) as you can see I am using an "apply to each" to achieve the adding of rows based on the qty entered, and a "switch" within to enter different information based on what region the order is being shipped to. Hoping this is possible as it will save a lot of manual entry, thank you to anyone who can get me going on the right path!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @adam0s

Your case actions might get quite big if you have a number of options, therefore have you considered using an array to store the options in and then a filter array that will retrieve the parameters relevant to each item of the apply to each? Then you only need to build the add a row option once. See here: https://damobird365.birdhoose.co.uk/2021/05/14/if-elseif-else-in-power-automate-simplified/

When it comes to the the tracking numbers, why not create an array and supply that to the apply to each? It looks like you are using range like 1,6. But you could instead create an array for the tracking numbers and apply to each of those values instead?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
adam0s 47 on at

Like (0)

Report

ok, read your article, watched a beginner tutorial on python and several other search queries, its been a steps forward and back process but starting to feel a little more confident overall:

I have simplified my testing environment for the purposes of understanding this one step:
I can get it to output the number of rows based on the number of "tracking numbers entered (represented here by just typing 1,2,3,4,5 in as the array) but I am still stuck on how to get it to output one tracking number per row in the table.
Currently I get this:
but looking to get each number into a separate row.

Was this reply helpful? Yes No