Power Automate Lesson 4: Excel Table to Reminder Emails

Power Automate Lesson 4: Excel Table to Reminder Emails featured illustration

πŸ“Ž This article includes 1 downloadable practice file ↓

⏱ 1 min readUpdated 12 October 2026

πŸ“˜ Power Automate Beginner Course Β· Lesson 4 of 8

In this article
  1. Prepare the Excel file
  2. Build the flow
  3. Where people go wrong
  4. Practice
  5. Continue learning

Renewals, document submissions, payment follow-ups: if they live in an Excel list, Power Automate can email people before they’re due.

Advertisement

Prepare the Excel file

Store it on OneDrive/SharePoint and format the list as a Table (Ctrl+T) named Reminders, with Name, Email, Item, DueDate and Status columns. Flows can only read tables.

Build the flow

  1. Scheduled cloud flow, daily at 9:00.
  2. List rows present in a table; set Filter Query Status eq 'Open'.
  3. Apply to each row with a Condition: due within 3 days.
  4. Send an email (V2) to the row’s Email with the item and due date.
  5. Update a row (key column: a unique ID) to set Status = Reminded.
⚠️ Excel stores dates as serial numbers; the connector may return 46299 instead of a date. Either store due dates as text yyyy-mm-dd, or set the action’s DateTime Format to ISO 8601.

Where people go wrong

Problem Fix
No table found Format the range as a Table
Only 256 rows read Turn on Pagination in the action settings
Reminders sent daily forever Update Status after sending

More: Excel to email reminders.

Advertisement

Practice

Follow the steps file with your own Reminders table.

πŸ“Ž Practice files for this article

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.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free Β· AI can be wrong

Leave a Comment