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.
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.
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...