Selecting the Data Collection

[devasaiprasad_K]

HI Team,

as seen in the below image, i want to select a data collection for out_val such that it should store the iteration result and the saved results should be pasted in outlook…

which one would be best COLLECTIONS or DATATABLE for out_val

[ashokkarale]

@devasaiprasad_K,

If you have single column or values then use collection, if you have multiple columns use DataTable.

Thanks,
Ashok

[devasaiprasad_K]

how about pasting the results back to outlook… as i have never worked with collections… we need to use again iteration to paste the data into outlook mail body?

[ashokkarale]

@devasaiprasad_K,

If you want to paste it as a string, you can do that by String.Join("",collectionVariable) It will give you string to be used in email body.

Thanks,
Ashok

[devasaiprasad_K]

how to fix the below, could you pls help.

i have declared out_val as List(of string)

[ashokkarale]

@devasaiprasad_K,

You will have to use Append Item To List activity for this.

Thanks,
Ashok

[Anil_G (Anil Gorthi)]

@devasaiprasad_K

Looks like you need whole of a collection out_AET to be saved or written into outlook…

If that is the case then you dont need loop …

You can directly convert whole list to string using String.Join(",",out_AET)

The above expression generates a string with comma separated values and can be directly used in the send outlook mail message

Cheers