Stay within the loop and add a new Step with Title as "Update Excel with SO Number". Let's add a few steps to update the Excel sheet:
- To concatenate the current row number and read specific Excel cells, we will convert the number variable currentIteration to String. Add the Number To string action to convert the currentIteration variable and assign the output to a new variable called currentIterationString that can be used as input or output (create this variable by clicking on the magic wand on the right of the input box). Your workflow should look like this:
- Now, let's set column I (SO#) in the Excel sheet with the SO number we got from the Child bot. Add the Excel basic Set cell action. In the properties, set Session name to S1, choose Specific cell and set it to I$currentIterationString$, which would translate to I2, I3, and so on and set its value to $dictOutput{SalesOrder...