Nov 14 2021 04:44 AM
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