Regarding the data in array

Help
1

hi,

I am getting the data from the after looping the email body also have extracted data which required.
I need save the looped data into excel problem is that only last data is stored in excel.

2

that is because u are not itirating the cell value in which you are writing.
if I’m not wrong in write cell activity you have selected “A1”.
This will rewrite the data in the cell for every itiration.

Data Store.xaml (5.4 KB)

Hope this would help.

Regards,
Ashley Nihal Dcunha

3

can you helps me save the looped data in array.

4

Capture1
Capture1433×530 13 KB

Please check attached sheet.

5

i would suggest you to go with the LIST instead of array.
the excel sheet is not available

7

OKAY but values is dynamic for every time it will work for same scenario

8

Capture3
getting the attached error try to change to string also but same error.

9

Hi @kiranh

You will need to change the type of your variable in the Variable pane. See here: