Create system entries based on 2+columns in Excel Worksheet

[LisaF (Lisa)]

The project:
Use UIPath to open and close tasks in an In-House ticketing system based on data entered into a spreadsheet containing 3 columns - Customer Number, Customer Email Address, Task Recipient Name

General process:
Open ticketing system
Click to “tasks” section
Type in customer number
Click Search button
Type in task name (task is same for all customer numbers)
Type in Note details
Click Send Task button
Click OK button
Type in Task Recipient username
Click OK button
Click check box to automatically close the task
Click Yes button
Click Clear button

Begin process again by typing in the customer number

Steps in the robot:
Sequence:
Open In-House system
Click Send Tasks section
Read Range (based on another robot I built to add contacts to Skype, but only used 1 column for that)
“Tasks.xlsx”
“Sheet1”
Range is empty

For Each Row
ForEach “row” in “Tasks”
Body
Sequence
General Process steps listed above

The robot will open the In-House System, click on the Tasks section and then I get the error “Object reference not set to an instance of an object.”

The Questions:

1. To set up the robot to read the spreadsheet and input the Customer Number, Email Address and Task Recipient Name from Column A, B and C on the spreadsheet, is this the correct format?

2. I have extremely limited understanding of how to use variables, however to simplify things for myself, I just created a variable call “Tasks” and put “Tasks” in the ForEach . . . section

Screenshots:

I have made several searches to find out how to fix the error “Object reference not set to an instance of an object” (which is really starting to look like “check engine” to me)
Exception Type: system.NullReferenceException
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.NullReferenceException: Object reference not set to an instance of an object.
at UiPath.Core.Activities.ForEach`1.Execute(NativeActivityContext context)
at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

I am extremely frustrated at this point, all of my searches for information to try to fix this on my own have failed and I would really just like for someone to say “type this in here, then type that in there and that will fix it”.

[Palaniyappan (Palaniyappan P)]

Hi
Welcome to uipath community
it seems like the datatable Tasks is not having value in it
Is the excel file path mention in READ RANGE ACTIVITY is correct and is the output obtained from the activity
If so to validate that before to the for each row activity use a Writeline activity and mention like this
Tasks.Rows.Count.ToString

Kindly try this and let know for any queries or clarification
Cheers @LisaF

[LisaF (Lisa)]

Thank you SOOOOOOOOOOOOO much! Turns out I didn’t need the Write Line activity, but I put the DataTable name in the Output field and it worked like a charm. I misunderstood what the “output” field was for - I thought that mean where UIPath would be putting any data that was produced for something like a report or “completed/True/False” type responses.

Again, Thank you very much!