Hello everyone, I have a workflow that is supposed to fill a form and I’m extracting the data that I’m going to write from a table present in the Data Base. How can I check for all the columns present in the row if any of them is Null or Empty?
Like if it is Null or empty don’t attempt to write it in the form, else write what you found.
use this in for each row in datatable activity, gives boolean output
CurrentRow.ItemArray.All(Function(a) string.IsNullOrEmpty(a.ToString.Trim))
CurrentRow.ItemArray.Any(Function(a) string.IsNullOrEmpty(a.ToString.Trim))
Hey @rodrigo.simao
Use this LinQ:
Row.ItemArray.AsEnumerable().Any(Function(x) String.IsNullOrEmpty(x.ToString.Trim))
Note: Row is a DataRow Variable!
Above query will give you output as True or False!
You can use query in If Activity and define the further workflow!
Screenshot for your reference!
Regards,
Ajay Mishra
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
