For each excel Row How do I message box counting out the numbers?

[oscar.o]

Hello!

I have a question about “Excel For each Excel Row”.

If “did” is 0, I want to show the number in the message box.

ex) 0 have eight.

If i check the “Write line”, 0 0 0 0 0 0 0 0 0
Eight of them come out well.

When “message box” is executed, it is written 1 on the message box and repeated 8 times.

I don’t know what’s wrong.

I’ll attach a capture image.
I’d appreciate your help.

[Anil_G (Anil Gorthi)]

@oscar.o

Remove .count in your message box…

Cheers

[oscar.o]

Thank you for Replying

However, it not been fully resolved.

message change “0” but Message box 8 is repeated.

I want only 1 message box NOT REPEAT & “C_C_C 0 have eight”

I also attached an Excel file.
practice.xlsx (11.8 KB)

[Anil_G (Anil Gorthi)]

@oscar.o

As per condition if number is less than 1 message bos is displayed and 0 is present 8 times in the given excel…Hence you are getting 8 times…

if you want to break or stop the loop once you find 0 then use break activity after the message box

cheers

[oscar.o]

If I put the brakes on it, of course I can stop it.

What I mean is…
I just want to see one message box…
that’s knowing “0” having 8.
Because it changes every time. I don’t want to put on a breakpoint, I want to show it all at once.

I apologize if my intention was not clear using a translator.

[Anil_G (Anil Gorthi)]

@oscar.o

Then use fa filter datatable and filter the required row with 0 and then use filtereddt.rowcount and in message box write

"0 is repeated " + filtereddt.rowcount.tostring

Or create a integer variable and initialize it with 0 …then in the then condition use counter = counter+1 in assign and get the count and outside the loop use

Msg box with "0 is repeated " + counter.tostring

Hope this helps

Cheers

[Gokul_Jayakumar (Gokul Jai)]

Hello @oscar.o
Refer to this Xaml file you will some ideas.
Forum_ExcelZeroCount.zip (147.1 KB)

[oscar.o]

Oh! i think maybe close to solution

There’s only one message box

i using filter datatable but still error

But… why saying 0…

Is there anything I missed?

[oscar.o]

Thank you for replying

you gave me works fine there’s no error!

However, the workbook is not available for dbf.

excel mean sample datatable…

i must using dbf so Use Excel File / For Each Excel Row…

Is it possible to apply dbf?

PRACTICE_2.zip (33.3 KB)

[Anil_G (Anil Gorthi)]

@oscar.o

Give the correct column number …column numbers start from 0 not 1…or give name as "did"… And try with "0"

cheers

[oscar.o]

Thank you very much for your infinite kindness.

It was very helpful to give warm consideration to beginner

cheers