Add data row error : object reference not set to an instance of an object

Help Studio
, , ,
1

Hello!
I’m having issues adding a Data Row. I’ve been browsing other forum posts on this topic and it seems like I’m making the right moves with ArrayRow and DataTable cells. Is my DataTable “Emailscrape” suppose to be already formatted in excel prior to starting the project? I’ve already initialized it in Read Range near the top level of the flowchart.

The error is System.NullReferenceException: Object reference not set to an instance of an object.

image
image1600×860 74.1 KB

2

@Austin_Hunter

Please can you check if the Data Table is initialized and share screenshot regarding to the Data Table.

I think the DataTable is null.

1 Like
3

Hi @Austin_Hunter

Please Check these things.

  1. After Building DataTable, Check in.
    Prioperties whether you have assigned a .
    datatable variable.
  2. Then In Add DataRow Activity check.
    whether you have added the same.
    datatable variable.

Regards
Pravat

4

Isn’t the data table going to be populated at the end of the flow with the Write range activity? How do I make the data table not null at the add data row activity?

image
image1581×814 64.4 KB

image
image1511×684 39.9 KB

5

Is this what you mean?

Initialized data table Emailscrape

image
image1599×859 74.1 KB

Same data table name
image

Flow chart macro

image
image1398×470 24 KB

6

Please try the following:

  1. I see the Range Chosen is from B1:F1, please remove this range selection and leave it as “”
  2. Try adding the Read Range within an Excel Application Scope and execute it.
    3 . Run in Debug mode and check what is the value of the DataTable after the Read Range activity
7

@Austin_Hunter

You can keep a condition after Get IMAP Messages as If GetImapEmailVariable.Count > 0, because you can’t except mails to be there, so if there is no mails then you will get the same error

Hope this helps you

Thanks

8

Hi @Austin_Hunter

Check whether in that mail folder in outlook contain atleast one mail or not. If there is no mail then your variable will hold null data and there will be exception while adding into datatable.

So please add atleast one mail in that folder in outlook then run your code in uipath.

Regards
Pravat

9

I’m getting a excel application scope error. Should I move this activity inside my For Each activity?

image
image1481×563 49.4 KB

10

Please move the Read Range within the Excel Application Scope. Example screenshot attached.

image

11

@Austin_Hunter,

Hello and Welcome to the forum. You need a condition before the add data row activity, your condition should check in all the variables you are trying to add to datable ant empty. Not var1.toString.isNullOrEmpty And Not var2.ToString.IsNullOrEmpty etc and then drag the add datarow activity inside so if one of the variables is empty this will not error out instead it will move to the else part.

12

I’m trying to get emails from gmail. ive enabled imap and allowed less secure apps to extract. Do you think its a problem on the gmail side?

13

Hi @Austin_Hunter,

Please follow below step and let me know working on gmail working or not:-

  1. For POP3 Mail Message
    Enabling Gmail for Email Activities
    follow the above procedure to configure Gmail:-
    image
    image964×499 25.3 KB

    Port: 995
    Server:pop.gmail.com

2.For IMAP Mail Message

image
image1309×909 133 KB

PORT: 993
Server: “imap.gmail.com”
Sample workflow as follows.
EmailAutomation.xaml (8.4 KB)
If it helps Please Mark it as a solution!!! Happy Automation :partying_face:

Regards,
Pravat

14

I’m not quite sure im understanding the format. Is the follow image congruent to what you said? I’ve also tried String.IsNullOrEmpty(mail.Body.ToString) and I didn’t get a warning but didnt work

image
image1600×860 61.9 KB

15

I think i did everything. configure IMAP settings, allow less secure apps, and nested the read range. I’m using my University gmail account do you think that could be the problem?emailscrapingTemplate.zip (6.8 KB)

16

emailscrapingTemplate.zip (6.8 KB)

17

I actually got text for some the assigned variables but it seems like my data table didnt update or get exported.

image
image1584×806 61.8 KB

18

image
image1584×806 61.8 KB

19

@Austin_Hunter
I can see the DataTable left blank here

image
image1273×372 15.3 KB

Please add the DataTable name Emailscrape in the highlighted area (In Yellow)and try again.

20

I’m still not getting emails to populate my data table. I think it might be because I’m using my school email. Do you see anything in the video that might cause the issue?