DataTable with Error NullReferenceException

Help
1

Guys, good morning, I’m creating a process that connects in access and allocates data from a table in the Datatable.
However some columns are null in the Source Table and when working with it I get the following error

erroNullRef

What is the best way to handle this type of error? because even though the column is empty and needs at least its value to be “”

Can you help me?

1 Like
2

@Rafaeloneil

Welcome to uipath community buddy and thats a good question to start with

Its not the issue either with message box or excel cell data…its about the null value been referenced by a variable and when we try to get the referenced null value, we get this sort of error, to handle this and get atleast string.Empty as you expect “”, we can validate whether it is null or not with some condition may be a if condition
before printing it with messge box, assign that text to a variable and try to validate like this
in if condition
String.IsNullOrEmpty(out_text)

If that s empty in then part print in message box like
string.empty

or in else part print like
out_text.ToString

May be this can help you buddy , refer this xaml

Thats all buddy you are all done
Sequence.xaml (7.2 KB)

Cheers

1 Like
3

is that working buddy @Rafaeloneil

4

It worked perfectly, thank you very much!

1 Like
5

Cheers buddy keep going

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.