How to get the values of a data column to a string

[ppr (Peter Preuss)]

The Classical Way:
Iterate with for each row and add first column to a collection of type List(Of String)

The one liner
define a variable: eg. name: StringListVariable type: List(Of String)
Use an assign activity
To: sl,
Value: YourDataTableVariable.AsEnumerable.Select(Function (row) row.Field(Of String)(“YourColName”)).toList

Later you can easy bring the string list to flatten string eg. String.Join(“,”,StringListVariable.ToArray)

For the one liner way make sure System.Data.DataSetExtensions is imported
Have a look here:

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.