Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Order Status - Power Automate

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
Categories:
  • Tom_ikapa Profile Picture
    Tom_ikapa 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
    YUN ZHU 73,035 Super User 2024 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
  • Verified answer
    HVGEEL Profile Picture
    HVGEEL 288 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans