How can Logic Apps avoid repeatedly ingesting previous Excel data when triggered by new entries for SQL Server integration?

Question

How can Logic Apps be configured to trigger only for new row entries from an Excel file and then ingest them into SQL Server? Currently, when someone modifies the Excel file in SharePoint, Logic Apps repeatedly ingests other data from previous dates into SQL Server. Is there any possible solution, to read only the new added rows?

Answer 1

@Ceeeee-8261 Thanks for reaching out.

Only actions are listed as documented in the Excel connector for logic app.

There are two workarounds to handle this in logic app.

• Delete all the existing rows or drop the table if you are storing the same excel sheet data for the same table. You can use sql connector to perform this operation.
• In case your table has other data, and you cannot delete all the rows/drop the table then you need to leverage the SQL connector to first to validate whether the row exists. You can use Execute a SQL query (V2) action with where condition to match all your column with the current row in the table. Using condition statement if it returns a single row then skipped it else use the Insert Row (V2) action to insert the data.

Let me know if you have any queries or concerns.