Count in Excel how many entries are present

(0) Share

Report

Posted on by PatrickSched

212

Hello all together

I would like to count via Power Automate in an Excel table how many entries of a value are present in a column.

For example: how often is "123456" present in column "H".

Thank you for your help 🙂

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PatrickSched

Assuming your excel is on onedrive and "EmployeeId" is the header name for col H. You can get the rows by using "List rows of a table" action:

and using below expression, you can get the count of rows:
length(outputs('List_rows_present_in_a_table')?['body/value'])

Please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

Hi @ManishSolanki

perfect, it works.
Can I specify multiple filter options in Filter query?

For example:
Filter me in column "H" all entries with "123456" and in column "A" all entries where the cell is empty.

So it does not work for me and I get an error message

Thank you for your help 🙂

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @PatrickSched

The query looks ok but syntactically it is wrong. Only thing you need to do is to replace comma before Status with "and":

<<first part of query will be same>> and Status eq ''

Please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

hi @ManishSolanki

I have entered it as follows but I get an error message

Do you know what I did wrong or what the problem is?

Thank you very much! 🙂

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

@ManishSolanki

You have given Artikelnumber eq the variable
but in Status eq what? that is missing can you complete the expression

Hope this may help you

Thanks,
Srini

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @PatrickSched

Please remove comma ',' before and keyword as highlighted below:

Thanks

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

Hi all together,

When I search for an item number (is a dynamic content) in the "Item number" column, it works.

Now I want to count only the entries in the column "Status" where the column is empty.

This is how the function should be:
Search in column "Item number" for an item number and in column "Status" for cells that are empty.
What is the command?

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

This is the error message
'Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.'

and this my flow which don't work

what im doing wrong?

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

Ok, I have another option but again I need your support.
I can also do the whole thing using a SharePoint list.
I have in a column (Title) the number.
In one column I have the date of creation. How can I count only the entries to which the article number fits and the creation (Column "Erstellt") is not older than 21 days ago?

Was this reply helpful? Yes No
PatrickSched 212 on at

Like (0)

Report

ok, i tried it again in excel, but i don't work.

Error message:
"Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.".

Have anyone an idea? 😞

Was this reply helpful? Yes No