DataRow property in AddDataRow activity

[Athrix05]

Has anyone used the DataRow property in AddDataRow activity?
If yes, could you please give a sample?

[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

[oscar]

Hi Lahiru,

Just want to thank you for this quality post! You shared a number of solutions to this problem, and I really appreciate it!!

I especially like using the Invoke Method activity, it is straightforward. I also learned that I can copy a skeleton of a DataTable by using the Clone method, which is much better than building the entire data table by hand.

[Lahiru.Fernando]

Hey @oscar

Thank you for your great commit buddy!!
And I’m glad to hear that my answer was very much helpful to you…
Thanks again!!!