cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stacy-lvcva
Frequent Visitor

General Question about approval workflow

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?

 

 

1 REPLY 1
manuelstgomes
Super User
Super User

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,273)