Argument value error

argument value error
when I was passing the name from read range activities to for each activitie getting error.
In read range activitie, when I was typing CurrentRow by default is not getting.


I clearly showing in screen short,
pleas help me.

use for each row in datatable instead of foreach
image

You have to use For each row Activity to loop data tables.

For each is for collections like array & List

Hello @447_J_U_S_SANDEEP ,

When you use Read Range Activity you will get the output as DataTable variable. Inorder to loop through each row in the Datatable, you have to use “For Each Row In DataTable” Activity.

CurrentRow will represent each Row and You can use the Index( CurrentRow(0)) or the ColumnName (CurrentRow(“Name”)) to get each values from the row.