Using PowerApps Business Central Connectors not updating Sales Order status

(1) Share

Report

Posted on by Trinity365

I want to Reopen a Sales Order in Business Central from PowerApps, so I m using following formula:

Patch('salesOrders (v2.0)',LookUp('salesOrders (v2.0)',number = _varSalesOrder.number),{status:"Open"});

It is not updating anything in the Business central, can anyone suggest what is the process outside Business central If I want to reopen Sales order and create shipments?

Thanks in advance!

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (1)

Suggested answer

YUN ZHU 84,557 Super User 2025 Season 1 on at

Like (0)

Report

RE: Using PowerApps Business Central Connectors not updating Sales Order status

Hi, yes, I think you need to create a new API page.

More details about api page:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

Or you can try the following, which is similar to the sample I provided:

Creating and Interacting with an OData V4 Bound Action

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-and-interacting-with-odatav4-bound-action

Hope this will help.

Thanks.

ZHU
Trinity365 on at

Like (0)

Report

RE: Using PowerApps Business Central Connectors not updating Sales Order status

Hi yzhums ,

Thank you so much for your reply!

The Video link that you shared is very informative but I am new to Business Central and AL development.

I have few questions:

Do I need to create new page as you showcased in that article to Release and Open sales order in BC? Creating new page will create new data model or API?

Can you share any link for that if you have any reference, please?

Sorry if I am asking very simple questions!
Verified answer

YUN ZHU 84,557 Super User 2025 Season 1 on at

Like (1)

Report

RE: Using PowerApps Business Central Connectors not updating Sales Order status

Hi, as Josh mentioned, You should not modify the status field directly, you should use another method.

It is recommended that you refer to the standard Release and Open code, and then add custom execute actions.

https://yzhums.com/20111/

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 95 on at

Like (1)

Report

RE: Using PowerApps Business Central Connectors not updating Sales Order status

You have to play it differently. In the regular UI no one can just alter the status field without following a specific process. The BC connector doesn’t have an action for doing this. Would mean a development as the field in the api is read only.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: Using PowerApps Business Central Connectors not updating Sales Order status

Hello,

If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.