Answered

Deleting records from on prem database from Power Automate

(0) Share

Report

Posted on by Jason Yeung

Hi,

I'm currently creating a Flow in Power Automate that queries the Account entity in Dynamics CRM (Cloud) and inserts it to an on prem SQL database. I was able to get the flow to insert the records to the correct table, but I want the flow to delete all the records in the table beforehand. (in an SSIS package, a SQL query like "DELETE table" would be executed before importing).

I was wondering how do I do this with Power Automate?

Sincerely,

Jason

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

timl 37,188 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JasonYeung

I guess the reason why you're asking this question is because the 'Execute a SQL Query' action isn't supported with on premise databases.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-action-through-an-on/idi-p/236400

The workaround is to create a SQL Stored procedure that deletes the data from your table. You can then call this stored procedure from your Flow.

Was this reply helpful? Yes No
Jason Yeung 53 on at

Like (0)

Report
Copy link

Link copied!

Hi @timl ,

Thanks for your help. The stored procedure worked.

Sincerely,

Jason

Was this reply helpful? Yes No
oscar_bolanos 13 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have created a SQL Stored procedure (on-premise) to delete the data from my table, however, the store procedure "sp_deleteTable" isn't shown within the "procedure name" dropdown (as is shown in the image attached).

Do you have any idea??

Was this reply helpful? Yes No