Add data row after build data table

[A_Learner]

Hi,
I have built a data table with different data types string, boolean, number and Date.
How do I add rows to this data table using Add data row. Do I need to follow formatting?

Thank you.

[Julian_Muhlbauer (Julian Mühlbauer)]

@A_Learner - Try this out and adjust it to your needs.

[A_Learner]

Thank you. getting an error.

[ashokkarale]

@A_Learner,

Pass the ArrayRow like this.

{"John Doe", True, 30, new DateTime(2024, 11, 19)}

[A_Learner]

Thank you. Getting error too. Option strict on converting int to string, date to string etc.

[ashokkarale]

@A_Learner,

It’s your column sequence mismatch. Can you show the columns and their datatype of datatable?

Depend on the column datatype, we will have to pass the values.

[A_Learner]

yes, I am matching sequence. Strangely it is allowing strings only. Any other data types throwing error.

[ashokkarale]

@A_Learner,

Here I tried to replicate this.

Datatable:

Code:

I changed the ArrayRow to this as it was giving me the same error. Try the below in ArrayRow this should work.

New Object() {"John Doe", True, 30, Now}

Output:

[A_Learner]

I am trying in Studiox. Still giving me an error saying value of object cannot be converted to datarow. Just strings and int. Removed date to be simple.

[ashokkarale]

@A_Learner,

Put it in Add list as row like this.