Forum Discussion
morteza692003
Nov 14, 2021Copper Contributor
Data connection retrieve 1000 row only
Hello Dears,
I have a problem regarding to retrieve data from a SQL connection in InfoPath form. I added the SQL connection in data connections section and it will retrieve the data when the form opened but it seems this connection has 1000 row limit so it retrieve only first 1000 row of the table (our table has more than 5000 row).
I would appreciate if you could help me regarding to this issue.
SharePoint Version: 2019 On-premise
SQL Server Version: 2017
Thanks in advance
No RepliesBe the first to reply