Looping of list from Excel


#1

I am trying to automate incident reassignment, I have list of tickets which come in Service now which gets assigned to Engineer in a loop.
For example: 1 ticket to 1st Engineer , 2nd to other Engineer and so on… Let’s assume I have 2 Engineer in shift. I was able to make the RPA for the same.

I was not able to use loop the list, hence right now I am using for each Row and my excel look like this

image

However, all I am want is loop 3rd ticket to get assigned to 1st Engineer again and so on loop to continue. How achive this?


#2

@sharath.f.kumar

Refer this post

you can group it and assign it to the respective Engineer…

Regards,
Mahesh


#3

Hi @sharath.f.kumar,

Create maxValue variable integer and assign value =1
Loop through the datatable after completing each row increase the count, once reach the value is 3 change the engineer and reset the maxValue to 1. Do the same .

Regards,
Arivu