Get the data from column in the same row


I have a for each row loop. If condition is met in for example row 3 then I would like to get the value from cell f3. I have something like this in read cell activity: “f”&senderEmailsDT.Rows.IndexOf(row) but here I get f0 cell, not f3. How to get the number of row that i’m currently in?


To the get index of row u are working

There is index property panel of for each row.

Create a varaible there which store the row index of current iteration.
For eg if want to read the A1 Cell which has row index 0

Then in general for any rowindex index

Then the cell written as


Hope the idea helps you


Nived N :robot:

Happy Automation :relaxed::relaxed: