My add row activity or Write range activity overwrites the existing values, how can we make it to enter data in the second row

My add row activity or Write range activity overwrites the existing values, how can we make it to enter data in the second rowMain.xaml (16.4 KB)

Is there a way to make it enter data into the new row, thanks

Hi @u322805

Since u are placing the build datatable and write range under the loop, it will create the datatable everytime and overwrite the existing data.

so to tackle that , i had placed build datatable at the beginning of workflow and the writerange at end. In the loop add datarow is placed so that it will update the data one by one.

Check this updated workflow

Main_1.xaml (16.4 KB)

Regards,

Nived N

Happy Automation

1 Like

You were of great help @NIVED_NAMBIAR , thanks a ton. It worked :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.