Input values from variable in a row side by side

[O_Prince (Prince)]

I have some values saved in a variable and would want to pass those values to the next empty row on the StudentName row and then also fill other values side by side on the same row. I previously tried reading next available row in each column but it inputs those values into the wrong row on other columns.

[supriya117 (Supriya Allada)]

@O_Prince

Check with if condition in the for each loop
String.IsNullorEmpty(Currenrow(“YourColumnname”).toString)
then
assign1:Currentrow(“YourColumnname”) = “value1”
assign2:Currentrow(“YourColumnname”) = “value2”

[rlgandu (Rajyalakshmi Gandu)]

@O_Prince

Use append range activity in your workflow

[B_H_Akshatha_Pai]

->Loop through the rows of datatable using a “For Each Row” activity.
->Inside the loop, use an “If” condition to check if the “StudentName” column is empty for the current row. You can access the value of the “StudentName” column using row("StudentName").ToString.

hope it helps