Skip to main content

Notifications

Community site session details

Community site session details

Session Id : muuAdrwJPXBL3P72A3RkqH
Power Automate - Building Flows
Answered

Counting rows in excel table

Like (0) ShareShare
ReportReport
Posted on 13 Nov 2020 16:37:00 by

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?

 

flow1113.PNGflow13.PNG

  • DeborahJoy Profile Picture
    19 on 10 Jul 2024 at 16:22:31
    Re: Counting rows in excel table

    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. 

  • daquilje Profile Picture
    5 on 13 Aug 2023 at 00:06:28
    Re: Counting rows in excel table

    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

  • jdaniel1 Profile Picture
    81 on 01 Mar 2023 at 20:29:54
    Re: Counting rows in excel table

    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. 

  • thelemontree10 Profile Picture
    17 on 14 Jul 2021 at 10:15:32
    Re: Counting rows in excel table

    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 ?

  • Verified answer
    Community Power Platform Member Profile Picture
    on 13 Nov 2020 at 21:47:23
    Re: Counting rows in excel table

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

  • Verified answer
    Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 13 Nov 2020 at 21:45:55
    Re: Counting rows in excel table

    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.

     

  • Community Power Platform Member Profile Picture
    on 13 Nov 2020 at 17:16:48
    Re: Counting rows in excel table

    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

  • Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 13 Nov 2020 at 16:41:59
    Re: Counting rows in excel table

    numberOfRows.PNG

    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 😙

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started
Loading complete