delete row after 24 hours from sql server

(0) Share

Report

Posted on by afernando

253

Hi,

I am trying to make a simple flow to delete a row after 24 hours since it was created from a SQL server. I can find a lot of templates connected to SQL servers but I cannot seem to find a way to add a step to call the sql server.

Any suggestions?

Cheers.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi Afernando,

I guess that you want to trigger your flow by “when a row is inserted in SQL server”. But it seems that there is no trigger about SQL server can be used currently.

If I understand you correctly, I would suggest you vote this related idea at here:
https://powerusers.microsoft.com/t5/Flow-Ideas/Trigger-based-on-INSERT-A-ROW/idi-p/3175

Thanks for your feedback. I would also report and collect this from my side.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @afernando,

Set a DateTime created field in your SQL table.

Add a recurrence flow, set the frequency to 'Day' and interval to '1'. User the SQL 'Get Rows' template and check the DateTime against todays date. If date is more than a day then use the Delete Row template to delete the record.

Thanks

Was this reply helpful? Yes No