0

I would like to know if I can create a logic app in azure where a SQL database is consulted, the information found is sent to the user by e-mail and he has the possibility to accept, reject or modify this information. Finally, I would like to overwrite the information if it was modified by the user in the database.

If it can't do this procedure, what do you recommend I should do?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Daniela
  • 21
  • 2
  • Yes you can: [there's a Logic Apps template for running a SQL Stored Procedure](https://stackoverflow.com/questions/63618226/azure-logic-app-how-do-i-call-a-stored-proc-using-a-connection-string-from-a-va) directly from a Logic App. Note that Logic Apps don't support long-running procedure (more than ~3 minutes or so), for that you need to use _Automation Accounts_ instead. – Dai Nov 22 '22 at 04:56

1 Answers1

0

Yes, you can do that by following below process: Firstly, I have created logic app with below trigger:

enter image description here

Here in Select query, I can call Stored Procedure or the table which is modified:

enter image description here

Then you will get a mail for approval.

For multiple approvals reference. After approval you can modify SQL table using same logic app workflow or you can create an another workflow for that.

RithwikBojja
  • 5,069
  • 2
  • 3
  • 7