web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Platform Community / Forums / Power Automate - Building Flows / Length Function for Ov...
Power Automate - Building Flows
Answered

Length Function for Overall Row Count on a Dataverse Table

Like (0) ShareShare
ReportReport
Posted on 8 Apr 2023 12:35:27 by ctedesco3307 659

Hey all - I'm trying to do a really simple flow to just count the number of records in a Dataverse table  - all I'm doing is this 

length(outputs('List_rows')?['body/value'])

 

Problem is it gives me the wrong number  -I get 5000 and I know for a fact there are 15000 in the table. What am I missing? 

Thx

ctedesco3307_0-1680957303267.png

 

I have the same question (0)
  • Verified answer
    grantjenkins Profile Picture
    grantjenkins 11,059 Moderator on 08 Apr 2023 at 12:46:30
    Re: Length Function for Overall Row Count on a Dataverse Table

    By default, List rows will only return the first 5000 items. You'll need to go into the Settings of the action, turn on Pagination and set a Threshold larger than the number of items in your table. This will return the items in batches of 5000 up to the Threshold you have set.

     

    grantjenkins_0-1680957961670.png

     

    grantjenkins_1-1680957973548.png

     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 707 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 499 Moderator

#3
chiaraalina Profile Picture

chiaraalina 312

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans