Why 'For Each Row in Data table' cannot work

[Nattawadee_Srisai]

Hi!
I have a problem

I’d like to know why ‘For Each Row in Data table’ cannot work
Even though it had worked before.
and this ‘For Each Row in Data table’ is under Retry scope

Main.xaml (783.0 KB)

[srinic (Srini)]

Hi @Nattawadee_Srisai ,

Please post your error message or log here to review

Thanks

[postwick (Paul Ostwick)]

Are you getting an error message? Are there rows in DTNotApproved?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

hi @Nattawadee_Srisai ,
Have you checked this data table, is it blank? → check by data.rowcount()
or you can write it to csv or excel file see it
this ‘for each’ inside ‘If’, check test.xlsx

then before ‘for each’ you can check it after process with it

you can check by

regards,

[Nattawadee_Srisai]

there is no any error message
it just skip this for each row in data table

[Nattawadee_Srisai]

there is no any error message
it just skip this for each row in data table

[Praveen_Mudhiraj]

If your DtNotApproved data table is empty then it’s not executed the for each row in data table. So before going to loop… Verify the Datatable it’s contains the data or not

@Nattawadee_Srisai

[rikulsilva (Henrique Lima da Silva)]

Hi @Nattawadee_Srisai

Add a break point at for each row in datatable and run it in debug mode then see in locals panel if your DataTable has values

Cheers