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)))
@dnandhini232
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
Use the FlowChart for your scenario and add the activities accordingly.
Once go through the below xaml, hope it helps you 
Forum18thaug.xaml (13.0 KB)
