General Question about approval workflow

[Stacy-lvcva]

I have an ASP.NET MVC web application and I am using a power automate workflow for approvals of data changes within the application with an on-premise SQL Server database.

The approval process requires 2 serial approvers, i.e. supervisor has to approve before data owner if they are different users.

I understand that the current approval action allows approve/reject to be performed from an Outlook email, Team Chat, or Flow app.

I would like to also allow the approver to complete the approval/rejection action from the MVC web application where they would be reviewing the proposed change already. The catch with approving in the application does not allow the workflow to advance to the next approver if the on-prem data is set to approve directly from the application.

If there was a way to call the Flow REST API and complete the approval block by passing the JSON parameters that normally get passed when the Approve/Reject button is clicked in the notification platform of choice would enable the flow to advance on from the approval action.

Has anyone had to address this type of requirement?

[manuelstgomes]

Hi @Stacy-lvcva 

This is a tricky one but I've done some digging and found this for you. First how to Integrate a Custom API with Flow:

https://flow.microsoft.com/en-us/blog/integrating-custom-api/

Perform operations using the Web API

https://docs.microsoft.com/en-gb/powerapps/developer/common-data-service/webapi/perform-operations-w...

Flows are now stored in common data service and use the rich Web API.

https://docs.microsoft.com/en-us/power-automate/web-api

Hope this helps you.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel