Unanswered

Counting rows in excel table

(0) Share

Report

Posted on by Community Power Pla...

Hello I have a flow currently that creates a table in an email when an item is created in SharePoint. I want to get the value of the number of rows to enter in my email. How do I go about doing that?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

Paulie78 8,422 Moderator on at

Like (5)

Report
Use a compose step after your list rows action. Then use the following code:
length(outputs('List_rows_present_in_a_table')?['body/value'])
Use the output of your compose where you want to show the row count.

Please...
If I answered your question Accept it as a solution ✔️
If I helped you out, please give me some Kudos 👍
Thanks 😙

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you, that did work. Is there a condition so I will only get one email? When I ran this I got 5 emails, one for each row I am assuming?

Thank you

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

Do you have an apply each that you are not showing in your screenshot? Please try to take a screenshot of the whole flow as one. Instructions on my blog here:
https://www.tachytelic.net/2020/10/screenshot-entire-flow-power-automate/

If your problem is fixed, can you mark it as answered and then post a new question about your 5 emails? It should be an easy fix.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Yes I did have an apply to each. Thanks for the screen shot instructions too

Was this reply helpful? Yes No
thelemontree10 17 on at

Like (1)

Report

the list row just list maximum of 256 rows. If you go into settings, it can extend more but not exceed 5000. Can we have another ways without using List Rows ?

Was this reply helpful? Yes No
jdaniel1 83 on at

Like (0)

Report

Yeah, I just ran into the same problem. all these threads keep saying use compose. Which works fine, but it only spits out 256 rows. How do we get a full easy method of row count? Where in the setting do you change it? I couldn't find it.

I would prefer not writing up a full for each loop just to get a count. the file we have is fairly big, 24,000 rows roughly. So, we want to build a flow, but only test the first few rows initially.

Was this reply helpful? Yes No
daquilje 5 on at

Like (0)

Report

Thank you Paulie78 for showing me how to count the number of records in a table.

I would like to utilize this functionality to keep track of how many records are in a table, and create a trigger of "when a table in excel online is updated"

Best,
Joey

Was this reply helpful? Yes No
DeborahJoy 19 on at

Like (0)

Report

Thank for this! Although years later, really helped with something I'm trying to do.
One question - is there a limit to the number of rows the Length function can count in a SP list (as there is with CountRows)? I couldn't find this information anywhere.

Was this reply helpful? Yes No