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?
Can you attach your sample sequence and we can figure out the issue
The row index check should help. Kindly check if the condition and the path you inserted the handling code is in right section.
Let’s have two set of activities to avoid this error
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
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