Error: Object reference not set to an instance of an object. 111

Help
1

I am creating a Flow to read UPS tracking numbers from Excel sheet, open browser and search and write excel data back to a excel file.
In the Section ‘For Each Row’ , I am getting error Message: Object reference not set to an instance of an object.
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)

error1
error11558×857 61.3 KB

Sorry I wasn’t able to attach the main.xaml as forum doesn’t allow new users to attach files. So I have added the xaml file on Gdrive and shared it
https://drive.google.com/file/d/1wCRU-xVsZ7BSW9e0XYPw5dY-Y6LmAMSp/view?usp=sharing

2

Hi @tej004
Welcome to the community forum!

Is the ReadDT being properly built?

3

Thanks. Yes the ReadDT is VaribaleType:DataTable with Global Scope

4

Could you set a break point when you read the Excel file in and take a screenshot of the ReadDT value after?

5

OK, I will find out how to set a break point (yea thats how new I am to Uipath) and get back to you.

6

To set a break point:

  • Select the activity you wish to set the break point on.
  • Push the F9 button on your keyboard, this should add a red circle to the upper left corner of the activity.
  • Push the F7 key to run your program in debug mode.

More information can be found here: