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

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Andy Sather on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,712 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Trinity365 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,712 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No