Lookup Datatable Null Error

[Hulya_Cetinkaya (Hülya Çetinkaya)]

Hi,
When i’m searcing a value in a datatable, if the value is not exist, Lookup Datatable returns a null error. I am using RowIndex property , if the value not exist, so the activity returns -1 as row index, and so I can handle it. But I even do this, the activity gives the null error. How can I handle it another way?

[Sam_Abraham (Sam Thomas Abraham)]

Can you attach your sample sequence and we can figure out the issue

[Nithinkrishna]

Hey @Hulya_Cetinkaya

The row index check should help. Kindly check if the condition and the path you inserted the handling code is in right section.

Thanks
#nK

[Palaniyappan (Forum Leader)]

@Hulya_Cetinkaya

if the value not exist, so the activity returns -1 as row index

Hmm

Let’s have two set of activities to avoid this error

1. First if the lookup datatable gives output as -1 then it means the value is not there which happens by default
   I think you have this set up done already

2. Now cover this lookup datatable with TRY CATCH activity
   That is place the lookup datatable inside the try block and select the exception type as System.Exception and if any exception occurs it goes inside the catch and let your workflow to proceed further

Cheers @Hulya_Cetinkaya