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

Announcements

No record found.

News and Announcements icon
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 56
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
  • Suggested answer
    HVGEEL Profile Picture
    312 on at
    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.
     
  • Verified answer
    YUN ZHU Profile Picture
    103,670 Super User 2026 Season 2 on at
    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
  • Tom_ikapa Profile Picture
    56 on at
    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 753 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 583 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 302 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans