Start an Approval Flow to Patch data

[adgkred]

Hi,

So I have an app where user can see all record from a table (from an SQL server) and modify some values.

For now, users enter a new value, click on a button, and a patch is made on the table.

However I'd like to have the following feature. users enter a new value, click on a button, an approval flow is created, and if approved the patch is made.

I've done extensive research on how to do that, but I'm a little lost with all the functionalities of PowerApps and PowerAutomate and can't find anything to point me in the right direction. 

So my question is the following; can such a thing be done? If yes how so?

Thanks!

[HenriDesmet59 · Accepted solution]

Hello @adgkred ,

What you can do is to trigger the flow from you powerapps application.

You can pass in parameter the ID of the row to update, and the new values to update.

Then in your approval flow, you get those values and after the mail approbation, you can use a SQL action to patch your row.

Tell me if It's helps you 🙂

Henri

[adgkred]

I'll give that a try, thanks!