DataRow property in AddDataRow activity

[Lahiru.Fernando]

Hi @Athrix05

It seems we directly cannot use the DataRow property of the Add Data Row activity if the row we are getting is coming from a different data table. So there are so many work around solutions for this. We can use ArrayRow property of the same activity. or else, we can use the Invoke Method activity and use Import Row command to add data. However, I have two sample solutions in both approaches I just explained. That’s the only possible way which I found.

Check these files out.

AddDataRow.xaml (7.3 KB)
DateFilterAndInsertToDataTable.xaml (12.3 KB)

I have also found some posts on this topic

Copy Row from one DataTable to another

You can use ImportRow method to copy Row from DataTable to DataTable with the same schema A sample reference workflow attached here: ImportRow.xaml (9.9 KB) Regards…!! Aksh

Copy Row from one DataTable to another

Hello, The issue you are having with “Add data row : This row already belongs to another table.” can be solved by passing row.ItemArray from initial row and pass it to the ArrayRow property of the Add Data Row Activity. I would also consider the Merge data table activity which can be useful sometime. Cheers