How to resolve Add data row error


how can i resolve this issue

{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString, , ,CurrentRow(“Eligible”).ToString,CurrentRow(“Details”.ToString)}

new Object(){strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,nothing, nothing ,CurrentRow("Eligible").ToString,CurrentRow("Details").ToString}

we added following:

  • new Object() - to force the datatype of the array
  • filled up empty values with nothing
  • we fixed the closing ) for CurrentRow(“Details”).ToString
  • we ensured that " this type of double quote is used

Try like this @Sandhya_Gajare

{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,"","",CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}

Regards
Gokul

Hi @Sandhya_Gajare,

If you want blank entries you should make it like this.

{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,String.Empty,String.Empty,CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}

Regards
Ömer

Hi @Sandhya_Gajare

Use this in your ArrayRow Fields

{strName.ToString,date_HireDate.ToString,str_EmailPrimaryWork.ToString,"","",CurrentRow(“Eligible”).ToString,CurrentRow(“Details”).ToString}

What you done is

CurrentRow(“Details”.ToString) instead of CurrentRow(“Details”).ToString
And not given “” for empty strings

Regards
Sudharsan

Hello @Sandhya_Gajare

As per the data that you have provided,
Your expression seems to be valid but there is an error in the expression CurrentRow(“Details”.ToString). Instead, use as below.

CurrentRow(“Details”).ToString

Thanks

@Sandhya_Gajare

In your query you made two mistakes

  • CurrentRow(“Details”.ToString) instead of CurrentRow(“Details”).ToString
  • You used only ,, for the empty string, You must use "" or nothing or Empty.Tostring

Regards
gokul