Instead of Add to Collection

[Laura_Ringiene (Laura Ringienė)]

I need to create List(of string) in loop. But with Append item to collection I only get an empty list. I output the list with string.format(", ",mylist). If I specify a new list in the Output field, it outputs only the last item. How to correctly create a list and output it on screen using Append item to collection. I haven’t done the loop in the picture yet, because I don’t get the elements out without it.

[supermanPunch (Arpan)]

Hi @Laura_Ringiene ,

Have you tried providing the list variable in the Result property of the activity and checked ?

[Sudharsan_Ka]

Hi @Laura_Ringiene

You haven’t created variable in the result

Create one there and use that in the string.Join

Regards
Sudharsan

[ppr (Peter Preuss)]

We would use
String.Join(", ", sarasas) and not String.Format

[Laura_Ringiene (Laura Ringienė)]

prr thank you. With string.join i output, but after the loop, only the last entry in the list is displayed. The DB is a table of 4 rows

[ppr (Peter Preuss)]

have a look here:

@ppr

String.Join(", ", sarasas) and not String.Format

sarasas was used as there are all items appended

[supermanPunch (Arpan)]

@supermanPunch

Have you tried providing the list variable in the Result property of the activity and checked ?

@Laura_Ringiene ,

Apologies for the wrong suggestion, As the Activities got updated I did think that we would need to provide a resultant list as well in the Activity.

Kindly follow @ppr 's suggestion

[Laura_Ringiene (Laura Ringienė)]

But I have saved the collection to the output result myList, so Log Message is what I am referring to. If I specify String.Join(", “,”, sarasas) it outputs an empty string

[Laura_Ringiene (Laura Ringienė)]

I got empty line

My Items

[ppr (Peter Preuss)]

@Laura_Ringiene

I have saved the collection to the output result myList

lets do one by one:

Activities - Append Item to List

here we can refer to the collection (sarasas) and the item to append as mentioned

But in UiPath.System.Activities 22.10.1 we have some new feature as type argument is auto retrieved from the collection variable datatype

with the downgrade e.g. to 22.4.5 we get the old behaviour

In newer versions of UiPath we do have the UI as in your screenshots, i will come back to this soon.

@Laura_Ringiene Let us know which Version of UiPath.System.Activities is used in your project. Thanks

[Laura_Ringiene (Laura Ringienė)]

In my project

[ppr (Peter Preuss)]

Ok thanks.

Kindly note we also can do the List construction in a single assign activity

Assign Activity
sarasas | List(Of String) =
DB.AsEnumerable.Select(Function (x) x(0).toString.Trim).ToList

[Rahul_Unnikrishnan]

Hello @Laura_Ringiene

Please check the below video.

List and Array in UiPath | List activities in UiPath

Thanks

[Laura_Ringiene (Laura Ringienė)]

@ppr

DB.AsEnumerable.Select(Function (x) x(0).toString.Trim).ToList

It’s work. Thank you @ppr

[Laura_Ringiene (Laura Ringienė)]

Thank you @Rahul_Unnikrishnan

[Gokul_Jayakumar (Gokul Jai)]

@Laura_Ringiene

I got empty line

Hello @Laura_Ringiene
Use the same variables in Collection and Output properties.

[ppr (Peter Preuss)]

Perfect, so feel free to close the topic by
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum