Power Automate - Dynamics 365 Business Central -> Microsoft Teams
Budget: $10 – $30 USD
What I’m trying to build (Power Automate + Dynamics 365 Business Central → Teams)
Goal
I need a Power Automate cloud flow built that listens to Dynamics 365 Business Central and posts an alert to Microsoft Teams when a Posted Purchase Receipt contains any item from a whitelist I’ll provide.
Use the When a record is created (V3) trigger on BC purchaseReceipts (API v2.0), then query purchaseReceiptLines with an OData filter Document_No eq <receipt No>. Loop the returned lines, normalize fields with coalesce (e.g., Item_No/itemNumber, Quantity/Quantity_Base) and check if the item is in the whitelist (array variable).
If any match, build a message string and post to a Group Chat via Flow bot including Receipt No, Item, Qty, Description, and PO No. Deliver a working flow with clear variable names, robust expressions (toUpper/formatNumber/coalesce), and a short README. We’ll validate by creating a posted receipt containing a whitelisted item and confirming the Teams message appears.
Systems & connectors
Microsoft Power Automate (cloud flow)
Dynamics 365 Business Central connector (standard)
Microsoft Teams connector (post as Flow bot)
i have tried using ChatGPT to help, but keep running into more errors after errors.
Goal
I need a Power Automate cloud flow built that listens to Dynamics 365 Business Central and posts an alert to Microsoft Teams when a Posted Purchase Receipt contains any item from a whitelist I’ll provide.
Use the When a record is created (V3) trigger on BC purchaseReceipts (API v2.0), then query purchaseReceiptLines with an OData filter Document_No eq <receipt No>. Loop the returned lines, normalize fields with coalesce (e.g., Item_No/itemNumber, Quantity/Quantity_Base) and check if the item is in the whitelist (array variable).
If any match, build a message string and post to a Group Chat via Flow bot including Receipt No, Item, Qty, Description, and PO No. Deliver a working flow with clear variable names, robust expressions (toUpper/formatNumber/coalesce), and a short README. We’ll validate by creating a posted receipt containing a whitelisted item and confirming the Teams message appears.
Systems & connectors
Microsoft Power Automate (cloud flow)
Dynamics 365 Business Central connector (standard)
Microsoft Teams connector (post as Flow bot)
i have tried using ChatGPT to help, but keep running into more errors after errors.