Add a better format to Add Data Row when supplying values

[postwick (Paul Ostwick)]

Considering this post:

Using Add Data Row by creating a System.Data.DataRow object instead of ArrayRow

In an automation I am working on, a problem occurred because I was using ArrayRow in the Add Data Row activity. The issue is that ArrayRow relies on column position instead of column name. In this automation, the datatable is created by reading a JSON definition of the datatable from an asset, and using this expression to convert it into an actual datatable: JsonConvert.DeserializeObject(of datatable)(str_FilesArrayDefinition).Clone [image] The problem occurred because I updated the column …

It would be great if Add Data Row had an additional property that works the way Item Collection works in Add Queue Item:

Of course it would be column/value instead of key/value, although being able to supply a dictionary where the key is the column name would also be a useful feature.

This would give us the ability to supply the values based on specific column name, so column order/position isn’t relevant.