I am building a flow that needs to update 4 separate tables in SQL Server. These updates need to be wrapped in a transaction. I do not see a way to start a transaction in a flow, unless I missed something. My way around this is to write a stored procedure that accepts my data as JSON strings. I can then process those in the stored procedure. Does anyone have any samples on how best to accomplish this? I will be doing mostly Updates or deletes no adds (Done elsewhere). Or, is there another way to accomplish what I need.
Thank you.

Report
All responses (
Answers (