Cosine Similarity inside Power Automate from a Microsoft Dynamics NAV (Navision) Sales Line export, then use that score to automatically group orders into proximity batches for cold-chain picking.

NAV(NAVISION) Sales Line export — either from a scheduled query, OData feed, or Data Export Service Fields needed:

Document No. (Order ID)

Item No. (SKU)

Quantity

Power Automate Cloud flow with Excel (Macros) / Dataverse or direct NAV API access.

Concept Recap — Cosine Similarity

Cosine similarity treats each order as a vector of SKU quantities.

Formula:

Cosine Similarity = Summation(Ai X Bi)/ sqrt{(summationAi^2)}X sqrt{(summationBi^2)}

Where:

Ai = quantity of SKU i in Order A

Bi = quantity of SKU i in Order B

Power Automate Implementation Flow

Step 1 – Trigger

Manual trigger for testing

Later switch to Recurrence (e.g., every 15 min) to run automatically.

Step 2 – Get Sales Lines

Action: List records from NAVISION Sales Lines via OData / Business Central connector

Filter: Document Type eq 'Order'