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

Row ID to check unit cost zero on sales order line for power automate alert

(3) Share

Report

Posted on by MS-03120953-0

497

Hi,

Please advise what is Row ID to check unit cost zero on sales order line for power automate alert setup

Many thanks

Categories:

Microsoft Dynamics NAV

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

TarikJerkovic 354 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The Row ID is the sales line id, which represents its SystemId GUID.The standard Sales Order Lines API does not expose UnitCost(LCY), so it cannot be checked directly in Power Automate. A small custom API extension is required to expose the sales line ID and UnitCost(LCY).Power Automate can then use the returned ID as the Row ID and check whether the unit cost is zero.

Altrnatively, the extension could expose only a Boolean field such as Zero Unit Cost, avoiding exposure of the actual cost value

Kind regards

Tarik Jerković

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,765 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, Hopefully, the points mentioned in the example below will give you some hints.

https://yzhums.com/53993/

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 18,722 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,

For a Sales Order Line, Row ID is the line’s unique SystemId (GUID), not the Sales Order No. or Line No.; therefore, when using a Business Central trigger such as When a record is created or modified (V3) on the salesOrderLines API, select the trigger’s dynamic value RowID in any later Business Central action. However, to send an alert when the cost is zero, you normally do not need a separate Get record action—add a condition directly after the trigger to check whether unitCost = 0 (and, if required, that the line type is Item and quantity is greater than zero), then send the notification. Microsoft confirms that API v2.0 uses the immutable SystemId as the unique key for sales order lines.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 3,066 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, Row Id isn't the value you test for zero, it's the connector's unique identifier for the record, the API id GUID, which comes off the immutable SystemId. You use it to retrieve, update or link back to that line later, not to check cost.
The bigger problem, the standard API v2.0 salesOrderLines entity doesn't even expose Unit Cost. It gives you quantity, unit price, amounts, shipment quantities, related IDs, but no unitCost or unitCostLCY. So you can't just pick Sales Order Lines and build a condition on Unit Cost, the field isn't there to select. You'd need a custom API page (or a custom entity) that surfaces Unit Cost from the Sales Line before Power Automate can see it.
Also the trigger names, there's no "created or modified" one exactly. It's When a record is created V3, modified V3, or changed V3, that last one covers create/modify/delete together.

Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No