You’re offline. This is a read only version of the page.
I have a flow that uses a SQL Gateway to get info from our on-premise SQL server.
The flow grabs data from a SQL View, then uses 'Add Rows (Dataverse)' to insert the data into Dynamics CRM.
I tested the flow by limiting the SQL 'Get Rows' function to 10 rows. All fine.
When I remove that limit, the flow works, but it has stopped (Succeeded) after 2048 rows - there are around 13k rows in the SQL view.
Is there a limit somewhere that I'm not aware of?
Excellent, thanks, i didn't even think to check pagination! that seems to have fixed it 🙂
Hey @bjarvis
For sharepoint action get items when we click on three dots and go to settings of that action we can open the option of pagination and give a threshold of maximum 100000 items. Can you check for sql is it the same?
Currently I cannot check it on my personal account as sql is not connected for me. If its not there can you send how the sql get rows action looks like the fields etc, maybe we can modify those to get all your rows. (Hide the server name or other personal things from the action before sending the screenshot)
I hope this helps 🙂
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
