Power Platform Community Forum Thread Details

Hi all,

I have a conceptual question for the community here. For background, here is a layout of a flow that I am working on:

Trigger: When a file is created in a folder (This is an Excel file)
Get that file content and store it.
Get items from SQL Server table.
If there are rows in the Excel file content that do not exist in the SQL Server table, insert said rows into the SQL table.

To execute this task, I am using a series of loops and conditional statements. All works fine except for one thing: I am limited to 5000 rows when using the "Get Items" action for SQL Server. Is there any way to get around this? Can I utilize a stored procedure to do this task instead?

I am unsure of how to proceed and would love to hear any ideas from the group.

Thanks,

Farhan

Categories:

General topics