web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Stored Procedure not r...
Power Automate
Answered

Stored Procedure not running when using HTTP Request/Response

(0) ShareShare
ReportReport
Posted on by 24

My flow is setup to run a stored procedure when a webhook payload is received. It has 3 steps in order:

 

  1. http request
  2. http response
  3. execute stored procedure (V2).

 

When the webhook payload is sent the flow does not register that it has been received and you cannot view any activity in the run history . If you remove the stored procedure then the flow will register a payload is received in the run history and all the correct data comes through and can be viewed in the run history. In isolation from the http request/ response steps the stored procedure will run correctly if triggered manually.

 

It's as if the SP is breaking the ability of the flow from working even though it is the last step.

 

Has anyone else seen this before?

 

Categories:
I have the same question (0)
  • Verified answer
    btew87 Profile Picture
    24 on at

    This is now resolved.

     

    The issue was with the http request schema being incorrect. I was, however, refferring to some of the json properties in the incorrect schema in a compose step and they were compatible which was confusing me.

     

    Solution was found by leaving the schema blank.

  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @btew87 ,

     

    Glad to see you resolved the issue.

    Please consider marking your own reply and it will help others with same question. Thanks.

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard