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.
Please can you check if the Data Table is initialized and share screenshot regarding to the Data Table.
I think the DataTable is null.
Please Check these things.
Regards
Pravat
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?
Please try the following:
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
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
I’m getting a excel application scope error. Should I move this activity inside my For Each activity?
Please move the Read Range within the Excel Application Scope. Example screenshot attached.
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.
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?
Hi @Austin_Hunter,
Please follow below step and let me know working on gmail working or not:-
2.For IMAP Mail Message
Regards,
Pravat
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
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)
emailscrapingTemplate.zip (6.8 KB)
I actually got text for some the assigned variables but it seems like my data table didnt update or get exported.
@Austin_Hunter
I can see the DataTable left blank here
Please add the DataTable name Emailscrape in the highlighted area (In Yellow)and try again.
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?
