Hi @t45521502, Welcome to the UiPath community!!
In the image I can see that, you’ve given default value as Cap for your lookupValue variable, and done your process successfully for that value only.
But now, you want to do the same process for all 3 values. so to achieve the same, firstly remove default value, don’t specify anything there, keep it empty as shown in below shot.
To do same process for each row in excel we use For Each Row activity, follow these for your workflow.
- Use Read Range activity, in excel application scope to get excel data in DataTable variable, make sure to uncheck AddHeaders property as you have no headers in excel sheet (direct data) and create output datatable parameter by using ctrl+k and it a name —> DT
- Use For Each Row specify that DT datatable here.
- Use Assign activity inside that for each row, like this
lookupValue = row(0).ToString.Trim
to get value from first column (for each iteration).
- Use your actual process here, sequence of your activity, which you’ve done previously.
here’s screenshot for your better understanding,