Excel Count

(0) Share

Report

Posted on by neill_long

728

Hello,

I have a flow that filters rows from an excel spreadsheet and then counts the rows that meet the criteria. However, it doesn't provide the correct count.

There are for example 5 rows currently in the table that match the criteria, when a new submission is added that is part of that criteria, the count should display 6. However, it displays 5. Doesn't seem to take into account the newly submitted row.

The formula in the Compose 2 action is:

length(body('Filter_array'))
 
Is there something i am missing or need to add?
 
thanks

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Srini007 3,467 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you check is the Filter Array is returning 6 items? If not then you need to check if the condition is really met?

If I have answered your question, please mark it as the suggested answer. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
neill_long 728 on at

Like (0)

Report
Copy link

Link copied!

the Filter Array shows 5 returned items. It doesn't show the item which is added to the list at the start of this process.

The Submission Date however, is all the same dates so should meet the condition. it's like the results need a refresh.

When the response is added to the spreadsheet, i then list rows present in a table and have a query on that:

On the test run i did, it shows 5 submissions. so again that is not displaying the newest item, which has the same Student_ID. I am just resubmitting a test run so info is all the same.

Was this reply helpful? Yes No
Suggested answer

neill_long 728 on at

Like (0)

Report
Copy link

Link copied!

so i think i have resolved this. i added a 5 minute delay after the add a row into a table and it then lists all the rows. sync delay was causing the issue.

Was this reply helpful? Yes No