Skip to content
Book a demo
Open the menu Close the menu
Call us 06 59 01 09 31 Book a demo

One Teams alert per overdue unpaid invoice

Each weekday morning, lists the rows of your invoices table whose Status is “Unpaid” and whose DueDate is before today, then posts one Teams message per invoice (number, customer, amount, due date). Expected columns: Number, Customer, Amount, DueDate, Status. Nothing is sent to the customers.

By
Loop & Roll team · Official
Copied
0 times
Steps
5
Version
1 · 18 October 2026
Requires
Loop & Roll 1.0.0 or later

Workflow graph

One Teams alert per overdue unpaid invoice Hover a node to see its role · Drag to move the graph
For each item of “For each invoice”Every weekday at 9:00 — ScheduleEvery weekday at 9:00ScheduleToday’s date — Compute a dateToday’s dateCompute a dateList overdue invoices — Table — list rowsList overdue invoicesTable — list rowsFor each invoice — LoopFor each invoiceLoopfor eachdoneAlert on Teams — NotifyAlert on TeamsNotify
One Teams alert per overdue unpaid invoice

How it works

  1. 1

    Every weekday at 9:00

    trigger.schedule

  2. 2

    Today’s date

    date.compute

  3. 3

    List overdue invoices

    table.list

  4. 4

    For each invoice

    flow.loop

  5. 5

    Alert on Teams

    notify.send

What you will fill in after import

Nothing personal travels with a template: connections, mailboxes, tables and recipients are left blank for you to pick in your instance.

Tables to choose
List overdue invoices · table
Secrets to fill in
Alert on Teams · webhookUrl

See also

More in Notifications

All templates