How add data in a column to collections and itterate for each activity for each item

Hai I have a date in excel one colum have data like this
Hari,Ravi,teja,bhanu,krishna
I have to add it collection and should itterate for each activity for each of the name can any one help me

Create a variable of type String[]
In your for each row activity you can do:
varNames = row("names").ToString.Split(","c)
for each name in varNames

@bcorrea I was new to Ui path if you don’t mind can you provide the example work flow please

Hi @bpt.teja1996
Kindly find the attched workflow for reference
Main.xaml (6.2 KB)

i will share the steps in screenshot too

this is overall view of workflow

1)first we assign the string “Hari,Ravi,teja,bhanu,krishna” to string variable name
2) next split the string name with delimiter as “,” by using code like this to names variable which is array of string datatype

names = name.Split(New String() {","}, StringSplitOptions.None)

next using for each loop activity we are looping through each element in the names array

Hope it helps you

Nived N
Happy automation

@NIVED_NAMBIAR thank you so much

Please mark it as solution too if u got it :slight_smile: @bpt.teja1996