📎 This article includes 1 downloadable practice file ↓
Advertisement
- Trigger: Recurrence, every 1 day, at 9:00, Time zone: (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi.
- List rows in Dues with Filter Query
Reminded eq 'No', DateTime Format ISO 8601. - Filter array: due date within 3 days:
lessOrEquals(item()?['DueDate'], addDays(utcNow(), 3, 'yyyy-MM-dd')) - Apply to each result: Send an email (V2) to
item()?['Email'], then Update row Reminded = Yes.
Run on 5 October 2026: S-501 (due 7 October) gets a reminder; S-502 (12 October) and S-503 (30 October) wait.
💡 Send from a shared mailbox (Send an email from a shared mailbox) so replies reach the accounts team, not your personal inbox.
⚠️ Test with your own address in the To field first. A loop error in a reminder flow can email every customer in the list.
Practice
Build the reminder flow pointing at your own email first. Build it in your own Microsoft 365 account at make.powerautomate.com, test it with the practice file, and check the run history.
📎 Practice files for this article
- 📗Dues tableThree invoices with due dates and a Reminded column.⬇ XLSX · 6 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong