web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Automate Flow on...
Power Apps
Unanswered

Power Automate Flow only returning 250 records from Dataverse

(0) ShareShare
ReportReport
Posted on by 195

I've got a stranage one.

I am trying to popuate table B with table A using a Flow, a very simple task. Table A contains 3200~ records, however when I try to do a List Rows it only ever returns 250 records. I've tried everyting, just a list rows with no filter, using fetch, deleting re-creating the flow several times, creating the flow from a different environment, creating the flow with another admin user, the list goes on...

 

I know the table contains 3200~ records from within MSSMS:

bfausti_5-1702710604006.png


as well as from the model driven app which lists the rows:

bfausti_6-1702710731072.png

 

I have tried everything and I don't understand what is happening. 

 

This is the flow:

bfausti_0-1702711062007.png

 

This is the result:

bfausti_1-1702711093610.png

 

Has anyone else had this experience before? Something is limiting the list rows returned I have no idea what is going.

 

Please help!

I have the same question (1)
  • Verified answer
    bfausti Profile Picture
    195 on at

    So it seems specifing columns in the flow fixed the issue:

     

    bfausti_0-1702776037214.png

     

    Has anyone experienced this behaviour before?

     

  • mstrblueskys Profile Picture
    14 on at

    Thanks for the fix! Listing the columns I needed for the flow resolved this issue for me as well.

     

    You did include your org details in the connection details of your solution, btw. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard