Azure Logic App is only inserting 100 rows into SQL Server table
I'm having a List in my SharePoint Online which is having 652 rows.
My aim is to insert these 652 rows into On prem SQL Server table.
I've a task Get items, followed by a For each and Insert row (V2) inside the For each.
In the For each settings I've switched on the Concurrency Control & the Degree of Parallelism is set to 50.
Every time I execute the logic app, I see that the execution is successful, but only 100 rows gets inserted into the SQL server table.
Any help will be highly appreciated. Thanks in advance 🙏👍
I test it in my side, it seems the problem was not related to "For each" Concurrency Control & the Degree of Parallelism. The reason for this problem is the "Get items" action of SharePoint connector can just get 100 records in default from the list.
To solve this problem, you just need to set the the parameter "Top Count" to 999.
By the way:
I guess the "Get items" action request the microsoft graph api in the backend to get items. And the graph api response 100 records by default, so it just get 100 records in your logic app (if you didn't set "Top Count" parameter). And we can know from the microsoft document, the $top parameter just support a maximum value of 999. So I guess the "Get items" action in logic app can also support a maximum value of 999(I'm not sure).
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by