Solution to count number of rows

Hi
Is there a way to count the number of rows in a sheet within a pabbly flow.

For example, I fetch all the rows in a flow using Get Rows action and then can I find how many rows were there in the fetch in the form of number, say 15, 25, 100 ?

Is it possible?

NOT Related to a particular flow. Just exploring if this is possible.

Hello @arsachdeva,

Yes, this is possible. You can count the number of rows fetched from Get Rows in a few ways:

1. Use the “rowIndex” of the last row returned by the Get Rows action — this directly reflects the row count.
2. Capture the Get Rows response in Advanced Format, then:
   
   • Use a Code by Pabbly step to count the number of objects in the array, or
   • Use an Iterator followed by a Number Formatter (Counter) to increment by 1 for each item.
     The final counter output will give you the total row count.

can we use Number formatter counter to control matching response number (i.e.1or 2 msgs.) chaflow messages when we get more match responses? I mean can we send only one or two msggs instead of all matched response?

can we use Number formatter counter to control matching response number (i.e.1or 2 msgs.) chaflow messages when we get more match responses? I mean can we send only one or two msggs instead of all matched response?

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
? Pabbly.com
?Rate your support