Find empty values in a datatable

@Shikhar_Tandon

first idea as a quick shot, use it within an assign, returning a list

(From d In dtData.AsEnumerable
Where d.ItemArray.Any(Function (x) If(isNothing(x), True, String.IsNullOrWhiteSpace(x.toString.trim)))
Select d).toList

with the check on returned list count with YourDataRowListVar.Count within an if activity
it can be reacted on result or no returned rows case.

Find Demo Xaml here:
GetRowsWithBlanksInAnyCol.xaml (7.7 KB)

Edited:
Statement saved up against Null Exceptions
Added Demo XAML

4 Likes