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.
Check the column name: Double-check that the column name in the Update Row Item activity matches the column name in the Build Data Table activity. Make sure that there are no typos or extra spaces in the column name.
Check the data table: Check the data table that you are updating to make sure that it contains the correct headers and that the column you are updating is not empty. You can use a Read Range activity to read the data table and a Write Line or Log Message activity to check the contents.
Check the data type: Check the data type of the name column in the data table. If the data type is not set correctly, it may cause issues when updating the row. Make sure that the data type is set to string.
Check the row number: Check the row number that you are updating to make sure that it exists in the data table. If the row number is greater than the number of rows in the data table, you may receive a null error.
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
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?