How to Count Total Successful and failed Transaction in Foreeach Row

Hi I wanted to count all the Successful and Failed transaction inside fore each row.

I have to fore each row (Stage 2 & Stage 3) in workflow Below.

Here is the Structure of my (Stage 2)

the output should looks like this in excel.

how can i Do that?
Thank you in advance.

Hi @Vincent_Nuestro

Looks like the condition row(“RPA”).ToString = “” will set the variable FlowState to “Success” instead of skipping [Continue activity].

So you could count all the datatable rows with this condition, row(“RPA”).ToString = “”

Success
DT.AsEnumerable.Where(Function(x) x.Item(“RPA”).ToString = String.Empty).Count

Failed
DT.AsEnumerable.Where(Function(x) x.Item(“RPA”).ToString <> String.Empty).Count

note: DT is DataTable variable

1 Like