I just need to delete duplicate entries from an SQL Table 😑

[wilfordm81]

Hi everyone!

If the title wasn't entirely obvious, I am certainly feeling defeated by Automate. I can't find a single relevant link regarding deleting a duplicate record from an SQL table - although plenty using Sharepoint- which I thought might've been a more common issue.

My Automated flow begins once an HTTP request has been received.

The next step is to 'Get Rows' from the SQL table, which have been entered from a previous flow (this used MS' Bing API to scrape certain news articles and place them into the table). The reason I want to delete some of the records, is because for whatever reason, I'm getting two of each from the scrape.

Then, once I have the rows, I obviously need to compare it to the original 'Get Rows' version, so I thought - initialise a custom variable, and compare the two for the following step, 'Delete row'.

But when I go to compare the two, only the custom variable exists, and the SQL table no longer comes up as an option.

Admittedly I am VERY new to Flow, but, surely it should be more simple...

Thank you in advance for reading, and for any potential advice.

W.

[teixeira]

Hi,

I remember having this problem and the way I did it was instead of using get rows, just directly using execute SQL Query. (test it first using select *)

Here's more details in the solution:

How to delete duplicate rows in SQL Server? - Stack Overflow

If this post helps you with your problem, please consider marking it as Accepted solution.If you like my response, please give it a Thumbs Up 👍

Have a nice day 😀

Tiago