Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Export Datatable into excel does not pull all the data

I have a power app built on MS team dataverse version.


  1. I have 1 screen where I display data from dataverse table called 'Participant' using Data table control in Power Apps
  2. I have another screen where I display data from 'Studies' table using Data table control in Power Apps

'Participant' table has 5000+ row and Studies' has few ~100 rows.


Then I implemented a Power Automate Flow to 'Export data from above tables to Excel in CSV format' - each table getting exported to Excel separately using just 1 flow.


Reference to how flow was built: Export Power Apps data to Excel in CSV format 


Issue:  When I click 'Export to Excel' button for 'Participant' table - I only get 500 rows exported instead full 5000+ rows, unlike on 'Studies' table I do get all the rows exported.

Is there any limitation on Data table control in Power Apps? or this could be Power Automate limitation that it cant process 5000 or so rows?


Screen Shot 2021-07-14 at 12.37.13 PM.pngScreen Shot 2021-07-14 at 12.37.25 PM.png


Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,081)