Flow decision not working with datatable variable

Hi , i am reading
a datatable from Excel sheet and storing it in DT1. After that I m filtering it using filter datatable activity and storing the filtered data in another datatable called DT2 . Now I want to check whether DT2 has rows or not. So for that I m using FLOW DECISION activity with condition DT2.rows.count >0 . While running flow I checked locals and i can see DT2 has one row . But my flow always goes to false. Even though my condition is satisfied.
Checked Datatable variable name and all. Everything is fine
Please help very urgent

check variable scopes / optionally run a WFA rule and check for Variable Overwriting checks

Use this syntax
DT1.AsEnumerable.Any(Function(r) DT2.AsEnumerable.Any(Function(x) x(“your column name”).ToString.ToLower.Trim.Contains(r(“your column name”).ToString.ToLower.Trim)))


Hey this is working fine for me


keep the variable type as boolean in LHS for assign activity and the syntax in RHS for assign activity

Use the boolean variable in Flow desicion

Hi @dnandhini232

Use the FlowChart for your scenario and add the activities accordingly.
Once go through the below xaml, hope it helps you :slight_smile:
Forum18thaug.xaml (13.0 KB)