Excel query

The data which I’m getting as output, I tried to write it in same excel sheet, for that, I provided the counter variable, but I,m getting only last data only in my excel sheet. plz, let me know how to write the data in that cell.
I have provided the file in questionexcel new column.zip (7.2 KB)

Hi @Animesh_Sarma,
Put the last activity inside the loop and check again. You need your counter to increase by one for each iteration.

EDIT: And you need to declare ‘counter’ variable before the loop so loop will know what is this variable.

Hi Animesh,

I have a working sample added, Pablito is right next to that set the default value of the COUNTER to 1 instead of 2.

Main.zip (17.3 KB)

Hi @Animesh_Sarma,

You are almost done buddy…kindly refer to the xaml attached, Just made small corrections

Main.xaml (9.6 KB)

Hope this would help you

Cheers…!