Is there any limit in passing values for Add DataRow activity?

Learn Academy Courses
, , , ,
2

Hi @Soundarya_Guduri

Yes, Based on the Input Data Table we need to pass the value inside the Add data Row activity.

If you using Build Data Table Need to set Max Length (-1), So it will take n rows

image

Regards
Gokul

3

HI @Soundarya_Guduri

If you set Max length as (100) , Here the Limitation is set as 100. So we can process only 100 rows

image

Regards
Gokul

4

My doubt is green arrow showing here … is there any limit creating variable here.?
image

This is the error we got in our workflow
image

5

HI @Soundarya_Guduri

Can you give all the String.Join in the variable and pass it in the Add data Row and check it.

Regards
Gokul

6

Can we add multiple variables (around max= 20) in ArrayRow property?
image

7

Yes @Soundarya_Guduri , You can add multiple variable in the ArrayRow.

Have you tried this?

8

yes but again got same error

image
image1293×247 63.4 KB

9

Can you share all this variable here? @Soundarya_Guduri

10

{str_PNRReference,str_PassengerTitles,str_FirstNames,str_LastNames,str_PhoneNumber,str_LastText,str_PostalCode,str_Address,str_Suburb,str_AllEmails,str_AddedDaysBookingDate,str_Reporthour,str_FlightClass,str_VehicleType,str_PickupTime,str_FlightNumber}

all are string type

11

give a try at Demo for a 2 column schema datatable
when VB:

new Object(){ColVal1,ColVal2}```

when C#

new object[]{ColVal1,ColVal2}

when all values should be joined to a single column
VB:

new Object(){String.Join(","new Object(){ColVal1,ColVal2}}```

C#

new Object(){new object[]{ String.Join(","new object[]{ColVal1,ColVal2}}```
12

we have tried but

image
image725×272 49.3 KB

13

see updated post or share your XAML

14

can’t share the xaml because its confidential . The expressions you have given , we are trying but its not working.

15

no problem, so give us clear details:

  • Studio Version

  • used UiPath.System.Activities Version

  • used Targetframework

  • Used programming languague

  • DataTable column structure

  • sample values (e.g. anonymized)

16

Studio Version = 2022.10.3

used UiPath.System.Activities Version = 22.10.3

used Targetframework

Used programming languague = VB.Net

sample values (e.g. anonymized)

below is the DataTable column structure

tableformat.xlsx (9.3 KB)

17

This issue occurred due to the number of arguments exceeded to add values in an array.

Instead of adding values into array create a dictionary and add values into that and then use funtion dicvariable.values.toarray

18

Hello @Soundarya_Guduri,
as of my knowledge there is no limit in adding Columns to a DataTable and thus no limitation in adding values in the activity Add Data Row - ArrayRow property.
I even tested it on my machine, see the attached screenshot.

Furthermore, it is not needed to wrap the Array in a New Object () instance since it is handled like that already by wrapping everything in curly brackets { and }.

I guess, that

  • there are values in the String.Join method that do not match
  • you missed a colon
  • the activity package has indeed an issue

Try out the following:
Create a new variable of Type Array of Object, take the activity Assign and assign the value in ArrayRow to the new variable. Then use the new variable in the ArrayRow property.
If the Assign already throws an error, then the issue is clearly within the array.

Tryout adding many values to ArrayRow:

image
image1867×1264 76 KB

19

Hi.

I am having the same problem. Has anyone found a solution? I can’t seem to add more than 16 variables.

Anyone have a workaround please?

20

Hey @CGhoST did you find a solution? I am having the exact same issue, i have 17 args…

21

I had the same problem. Apparently 16 variables is the limit.

Solution:
arr1 = {arg1, arg2,…arg16}
arr2 = {arg1, arg2,…arg16}
arr3 = arr1.Concat(arr2).ToArray

Use arr3 for “Add Data Row” activity.

image
image523×692 16.3 KB

1 Like