Error loop for DataExtract where the table is null

[Rodrigo_Habitat (Rodrigo Sousa)]

Hi everyone, I’m new here.

I have a flow, where I extract the data and store it. I need it to enter my IF if the extracted table is blank/null.
I have already carried out several tests but without success. I did some tests monitoring whether the table was being extracted (I tested using output datatable text) and it is extracted. And even though I have the if and the condition configured for the DataExtract =0 case, it does not enter my if.

Can you help me please? I’m building something for my work.

[Anil_G (Anil Gorthi)]

@Rodrigo_Habitat

the output of extract datatable is not extractdatatable right you have changed the variable…use the correct variable and check the count

cheers

[Rodrigo_Habitat (Rodrigo Sousa)]

@Anil_G

do e

Thanks Anil, i am perfom an test modify variable and return information case sucessfull or not.

[Eric_Alvarado]

@Rodrigo_Habitat Hi
Can you add a breakpoint in the If activity, then on the ‘watch’ or ‘immediate’ panel verify ‘ExtractDataTable.Rows.Count’; if you are getting a result >0 it means there’re rows in the data table
Sometimes, there could be 2 variables created under different scope; verified if there’re not variables under the same name

[Rodrigo_Habitat (Rodrigo Sousa)]

I did as you said, but now I have the following error “Argument “Condition”: BC30456: ‘Rows’ is not a member of ‘DataRow’.”.

I checked the ItensNF_Table storage variable and it is as System.Data.DataTable, so I don’t know why the problem. Any tips?

[Anil_G (Anil Gorthi)]

@Rodrigo_Habitat

in the context of for loop please change the name of current item to soemthign else other than the table name

cheers

[Rodrigo_Habitat (Rodrigo Sousa)]

OMG, very good Anil! Successful aplicattion, i’m for one verification a condition the variable “num_linha” using Assing for storage quantity row Data Extract, case “num_linha” = 0, continue for registrate product, else continue for update.