Low-Stock Threshold Alert to the Teams Channel

On a set schedule, this workflow checks every inventory record against its per-SKU reorder threshold and posts a consolidated low-stock report to a Microsoft Teams channel. Each line shows the item, its bin, current quantity, and the gap below reorder point.

Use it when stockouts catch the team by surprise and reorders happen too late. Run it nightly or every shift change so purchasing and the floor lead see exactly what needs replenishing before the shelf goes empty.

1. 1A schedule trigger fires at the chosen interval (e.g., start of each shift).
2. 2The flow reads all active inventory rows from Airtable, including quantity and reorder-point fields.
3. 3A logic step filters to only SKUs where on-hand is at or below the reorder point.
4. 4If the filtered list is empty, the run ends quietly; otherwise it continues.
5. 5An OpenAI step formats the survivors into a ranked, readable digest sorted by severity.
6. 6The bot posts the digest to the purchasing Teams channel.