1. Home
  2. Guides
  3. Power Automate
  4. How to schedule emails from Excel at each row's date and time in Power Automate
Power Automate

How to schedule emails from Excel at each row's date and time in Power Automate

Build a Power Automate flow that checks an Excel list every five minutes, sends each email close to its own date and time, and writes down when it was sent. No premium connectors and no SharePoint.

Jump to a step (12)
Who this is for

This is for small offices that want an email to go out on a specific day and at a specific time, like an appointment reminder or a follow-up after a visit. Outlook can delay one email you write yourself, but it cannot work through a list where every row has its own send time. This flow reads the list from Excel and sends each row when it is due.

You add the recipient, the message and the scheduled date and time in Excel. The flow checks the list every five minutes, sends any emails that are due and records the time in the Sent column, so each row only goes out once. It uses only Excel, Outlook and built-in actions. The expressions from this flow are free to download on this page.

What you need

  • A Microsoft 365 work or school account with Power Automate. No premium license is needed. The flow only uses standard and built-in actions: Recurrence, Convert time zone, Excel Online (Business), Filter array, Apply to each and Office 365 Outlook.
  • No SharePoint. The workbook is kept in OneDrive for Business.
  • No AI Builder credits. Filter array picks the due rows.
  • An Office 365 Outlook mailbox to send from.
  • An Excel workbook in OneDrive for Business with a table named Schedule and the columns ID, Name, Email, Subject, Message, Send at and Sent.

Step by step

0 of 12 done
  1. 01

    Prepare the Excel schedule

    Create a table named Schedule with the columns ID, Name, Email, Subject, Message, Send at and Sent. Every row is one email. Put the date and time in Send at in your business's own time zone, and leave Sent empty for rows that have not gone out yet. In the video the file Scheduled emails.xlsx is in OneDrive for Business > OneDrive > Video demos, but you can keep yours anywhere in OneDrive.

  2. 02

    Create a scheduled cloud flow

    In Power Automate, click Create and select Scheduled cloud flow. In Flow name type Send scheduled emails from Excel, and for Starting select 12:00 AM, a time in the past on purpose. In Repeat every type 5, keep the frequency Minute and click Create.

  3. 03

    Stop two checks from overlapping

    Click the Recurrence card and open the Settings tab. Turn on Concurrency control and type 1 for Degree of parallelism. Now only one check runs at a time, so two checks never work on the same rows. Power Automate says you cannot change this setting after you turn it on, so set it once.

  4. 04

    Get the time now in your time zone

    Click the plus icon (Add an action) below Recurrence, search for convert time zone, click Built-in and select Convert time zone. Rename the action to Time now, then fill in the fields:

    • Base time: click fx, type addSeconds(utcNow(), 30) and click Add
    • Source time zone: leave it as UTC
    • Destination time zone: I type Chennai and select (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi because my mailbox is on India time. Select your own business time zone, the zone of the times in your Excel file.
    • Time unit: type yyyy-MM-dd HH:mm and select Use "yyyy-MM-dd HH:mm" as a custom value
  5. 05

    Read the Excel table

    Click the plus icon below Time now, search for list rows, click Standard and select List rows present in a table. Select OneDrive for Business as Location and OneDrive as Document Library. Click Open folder, open Video demos, select Scheduled emails.xlsx and select Schedule as the Table. Open Advanced parameters > DateTime Format and select ISO 8601, or the Send at dates come back as serial numbers.

  6. 06

    Keep only the due rows

    Click the plus icon below List rows, search for filter array and select Filter array. Rename it to Due emails. Click the From field, click the lightning icon (Dynamic content) and select body/value under List rows present in a table. Click Edit in advanced mode and type the condition @and(empty(item()?['Sent']), not(empty(item()?['Send at'])), lessOrEquals(ticks(item()?['Send at']), ticks(body('Time_now'))))

  7. 07

    Loop over the due rows

    Click the plus icon below Due emails, search for apply to each and select Apply to each. Keep the name Apply to each, because the expressions in the next steps use it. Click the Select an output from previous steps field, click the lightning icon and select Body under Due emails.

  8. 08

    Add the email with To and Subject

    Click the plus icon inside Apply to each, search for send an email and select Send an email (V2) from Office 365 Outlook. Click the gear icon (Settings) next to To and select Use dynamic content. Click the To field, click fx, type items('Apply_to_each')?['Email'] and click Add. Click the Subject field, click fx, type items('Apply_to_each')?['Subject'] and click Add.

  9. 09

    Write the email body

    Click the Body field and build it in this order:

    • Type Hi (with a space at the end)
    • Click fx, add the expression items('Apply_to_each')?['Name'] and click Add
    • Type , and press Enter
    • Click fx, add the expression items('Apply_to_each')?['Message'], click Add and press Enter
    • Type Sparkle Clean (use your own business name)

    Leave Importance as Normal.

  10. 10

    Mark the row as sent

    Click the plus icon below Send an email, search for update a row and select Update a row. Pick the same Location, Document Library, file in Video demos and the Schedule Table, and select ID as the Key Column. Click Key Value, click fx, type items('Apply_to_each')?['ID'] and click Add. Click Show all, click the Sent field, click the lightning icon and select Converted time under Time now.

  11. 11

    Save and test the flow

    Click Save. The flow is now on and checks the list every five minutes. Click Test, select Manually, click Test, then Run flow and Done. If no row is due yet, the run succeeds and sends nothing, and you can open Time now to compare the base time in UTC with the converted time in your zone.

  12. 12

    Check the emails and the Excel file

    Open the mailbox that receives the emails. The email for the first row, a dental practice in the video, arrives within a few minutes of its Send at time, starting with Hi and the name, then the message. In Excel, that row now has a time in Sent, while a later row, an accounting firm, is still empty until its own check sends it.

Tips and common problems

  • The default starting time is later today, so the flow would not run until then. Pick 12:00 AM, a time in the past.
  • Each email goes out on one of the checks, usually within five minutes of its Send at time, not at the exact minute. The 30 seconds in the Base time expression are a small safety margin, so a row at 8:35 goes out on that check instead of waiting until 8:40.
  • Checking every five minutes uses about 1,500 actions a day when nothing is due. Microsoft lists 6,000 a day for a Microsoft 365 license. Checking every minute uses about 7,200, which is over that limit.
  • Use the exact column names from your Excel table in the expressions, including the space in Send at. If a name does not match, no row is ever due. A row with an empty Send at is never sent, and the run still shows as successful.
  • Do not use Filter Query on List rows. It cannot filter on less than, and Microsoft warns that filtered results can be out of date. Filter array does the filtering instead.
  • List rows returns 256 rows by default. Turn on Pagination in its settings for a longer list.
Still stuck? Ask AI to help you fix itChatGPTClaudeGeminiCopilotPerplexityGrok

Questions

Do I need a premium Power Automate license for this?

No. The flow only uses standard and built-in actions with Excel Online (Business) and Office 365 Outlook. It also does not need SharePoint or AI Builder.

Will each email go out at the exact minute in Excel?

Not exactly. The flow checks every five minutes, so each email goes out on a check close to its time, usually within five minutes.

Which time zone should I pick in Convert time zone?

Pick your own business time zone, the zone you used for the times in the Send at column. I use India time in the video only because my mailbox is on India time.

Why does the email action not show column tokens inside the loop?

Filter array does not give you column tokens inside Apply to each. That is why each column is read with an items('Apply_to_each') expression.

What if I only need to schedule one email I write myself?

You do not need a flow for that. Outlook can do it with Delay Delivery, and I have a separate video on it.

Video chapters

Files for this guide

ZIP
Schedule Emails from Excel at Each Row's Date and Time Power Automate
Download

Flow package (.zip)? How to import it into your Power Automate.

Ask a question in the comments Last checked 16 Nov 2026. Screens change: if a step looks different, tell me in the comments.