Can I check datatable outputs for a particular value using an IF statement?

[TRX (Tony)]

Hi,

I need to somehow check DT row value results for a particular variable value. If the value is found then populate a field. If the value is not in the DT then to throw an error. Is this possible please?

Thanks
T

[rikulsilva (Henrique Lima da Silva)]

Hi, @TRX

You can achieve this using the .Any method like this

dt_Invoices.AsEnumerable.Any(Function(x) x("NF").ToString.Trim = "131212312312312")

You can use any column to search for specifc value and compare. If at least one is found, the expression returns True

To throw a error, you can use Throw Activity and use this expression as example

new BusinessRuleException("Invoice not found")

As best practice you need to throw a Business Exception because System Exception is related to system fails etc

Solution

ExampleQueryDT.zip (2.8 KB)

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

HI @TRX ,
Similar topic

Use message box to display Sum data in Excel file

Hi @meli , [image] Is this your expect output? SumBox.zip (9.0 KB) This is source Regards

regards,

[TRX (Tony)]

@rikulsilva

dt_Invoices.AsEnumerable.Any(Function(x) x("NF").ToString.Trim = "131212312312312")

Thanks! This did the trick!

[TRX (Tony)]

Thank you @Nguyen_Van_Luong1