Power Automate: Trigger for Posted Sales Invoice does not return correct SystemId

(0) Share

Report

Posted on by gabeng

I posted about this issue in the Power Automate community, but maybe there is not enough overlap with Business Central users over there.

https://powerusers.microsoft.com/t5/Power-Platform-and-Dynamics-365/Business-Central-Trigger-for-Posted-Sales-Invoice-does-not/m-p/2426761

When I start a flow from a Posted Sales Invoice using the For a selected record V3 trigger, the flow will always fail because the SystemId that the trigger returns cannot be found in the salesInvoices table 112.

The reason is that the trigger returns the Draft Sales Invoice SystemId field and not the SystemId from table 112. The Draft Sales Invoice SystemId is not part of the API. So there is no way for me to know which Posted Sales Invoice the flow was triggered from.

This issue is identical in the public API v2.0.

Has anyone else run into this issue?

/gabeng_0-1698689979149.png/

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 75,595 Super User 2024 Season 2 on at

Like (0)

Report

Power Automate: Trigger for Posted Sales Invoice does not return correct SystemId

Hi, Standard APIs such as Sales Order and Sales Invoice do not directly use the Sales Header or Sales Invoice Header table, but use an intermediate table.

For example,

https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2SalesInvoices.Page.al

You can delete TABLE112 in the above steps and it should be ready to use.

Here are two simple examples. Although they are not exactly the same as yours, I hope they can give you some tips.

https://yzhums.com/34483/

https://yzhums.com/37458/

Thanks

ZHU