I’m getting first name and last name from screen scraping and doing some string manipulation and I’m using an Update Row Item but im getting the error that name cannot be null. I have the column header correct, i copied and pasted from the build dt activity. So i don’t know what can be causing this. Thank you in advance!
Check how many rows are available your datatable(finalContactDT)? and check whether your dtRowIndex variable value comes under your datatable row count.
hello @Tuannna1 and @Robinnavinraj_S here is my dt
and a few lines below is
Can you try to use AddDataRow activity before use UpdateRowitem?
You need atleast one row to update a datatable. If you want to add a new row on your datatable, you have to use add data row activity
@Robinnavinraj_S yea when you build the dt you have the first row that says “test” and i deleted it…but before that it was giving the same issue
@Yoichi i dont want to use add data row because each person will not have all the values for the column headers…
oh @Yoichi i see what you mean…i got it…sorry for that
Can you check the dtRowIndex value because starting row index of datatable is zero(0), if the dtRowIndex value is greater than 0 means change it zero and try again. If not please check the column name of your datatable. Copy the datatable column value and paste it inside update data row activity because sometimes you may have missed whitespaces
@Yoichi and @Robinnavinraj_S , thank you the add data row worked…now i get object reference not set to an instance of an object
please share you error and your activity screenshot
Looks like your datarow variable is empty, please assing a value before thje add data row
sorry @fernando_zuluaga , not understanding your response. can you please flesh it out a bit for me…thank you
you dataRow variable is empty at the moment you are trying to add into the datatable using the add data row activity, we can add empty values, can you check the value of your dataRow variable before add it?
How your are assigning the datarow value ?
i created another build dt activity, and now it has the first row with ‘test’ in the first cell of the first row and am still getting the same error
Hi @olmccb ,
Check this below workflow attached, this might help you in solving your issue’s
Uipath_UpdateRowItem.xaml (11.7 KB)
Hope this may help you