cancel
Showing results for 
Search instead for 
Did you mean: 

SQL server connection Row limit

Hi,

working with SQL server flow, we couldn't get  much than 512 rows.

Extend limit permit to create a flow of a access web app in a file like excel on google.

 

Status: New
Comments
Anonymous
Not applicable

We're running into this problem when dumping Dynamics 365 data into SharePoint Online. We have around 6000 records that the flow is addressing, but it only processes 512 before stopping without error.

Level: Power Up

This is due to one of the in-built functionality of MS Flow to list only 512 records by default. You can configure this by editing the settings on the "list record" action in your flow and turning the Pagination "On" and setting the limit manually - 6000 in your case @Anonymous. @Er_Dago 

Refer this article for more reference : https://community.dynamics.com/365/b/cosmansdynamcis365/posts/understanding-the-dynamics-365-list-re...