Logic app limitations

Question

Hi,

Is there any limitations in logic, the excel sheet has 5000+ records but it could only complete 256 entries in sql table. How can we increase this limit ?

Answer 1

I don't know the specific limit for Excel but know that the connectors are making API calls. Those APIs usually have some sort of throttling or limitation. The workaround is usually chunking or paging (breaking the request down into allowable blocks). Many APIs support the ability to request data in pages. Though this option is not usually available in the UI-based logic app connectors. You provide the number of records per page and the page number in the HTTP get request. You basically loop through the pages.

I also recommend looking for documentation related to the Excel connector for more information.

Answer 2

Hi @Niren Adhikary (NAD) Thanks for reaching out. This is known limitation The List rows present in table action returns up to 256 rows by default. In order to get all rows, turn on Pagination

Reference Doc: https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations-with-actions

I hope the answer helps. Please let me know if you have any further queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.