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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Order Status - Power Automate

(1) ShareShare
ReportReport
Posted on by 52
Good day 
 
I am trying to update the Sales Order status field from Open to Released using a Power Automate flow. However, according the error message on my flow and this document: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_salesorder all i can do is amend the status to /Draft/, /In Review/ or /Open/.
 
Is that correct? How can i amend the status top Released using Power Automate?
 
Thanks
Tom
I have the same question (0)
  • Tom_ikapa Profile Picture
    52 on at
    Order Status - Power Automate
    Hi Zhu and HGVEEL,
     
    I appreciate the feedback and clarity. i do have an approval process, but i am trying to do this via Power Automate. it's easier for me to monitor failures and amend than from within Business Central.
     
    Thanks for the feedback that there is no way to do this currently.  
     
    cheers
    Tom
  • Verified answer
    YUN ZHU Profile Picture
    90,070 Super User 2025 Season 2 on at
    Order Status - Power Automate
    As far as I know, the standard does not have an API action for Release. This field itself is not editable in the system.
    You can extract the Release code from the standard method and put it in the [ServiceEnabled] procedure on the API page. But this requires some customization.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    HVGEEL Profile Picture
    306 on at
    Order Status - Power Automate
    The real question is... is this actually possible? And is this at all a sensible thing to do?
     
    In a perfect world, setting an order from Open to Released is -as stated in your question- just amending the status.
     
    But there is so much more going on: Releasing an order is so much more than flipping a switch.
     
    The assumptions that you make when you 'just amend the status' are:
    (from the top of mind mind... there will be a lot more when you dig into the actual code)
    - there are no approval workflows for this order
    - there are no pre-payments for this issue
    - there is no custom code extension of the Release function that could prevent the order to be released
     
    My bottom line: you cannot simply flip the switch, unless your Power Automate flow is able to 
    - handle all errors being thrown
    - leave the order in Open if the flip fails.
     
     
    If you do need to make batch updates to Release multiple orders, why not try:
    The orders that cannot be released will then remain open, the eligible ones will be released.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,678 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,635

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,210

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans