I need assistance with a Power Automate that sends emails based on the information in an excel table.

Megan Garner 0 Reputation points
2025-08-28T19:01:50.7933333+00:00

I am working on a Power Automate that will send out a reminder email on Wednesday every week for the following Tuesday.
It is supposed to 1.Trigger: The flow starts every Wednesday at 10:00 AM (Eastern Time). 2.Get Data: It retrieves rows from a specific Excel table where the date matches today’s date. 3.Loop & Email: For each matching row, it sends a personalized email to the required attendees with session details (topic, date, time, location) and a reminder about submitting materials.

Below is what I have put together so far, and it is running but I am not getting the email.
User's imageUser's imageUser's image

User's image

User's image

User's image

User's image

Windows for business | Windows 365 Business
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Domic Vo 1,015 Reputation points Independent Advisor
    2025-08-28T20:25:41.6466667+00:00

    Dear Megan Garner,

    It sounds like you've structured the logic well to send weekly reminder emails based on data in Excel. Since the flow is running but emails are not being received, we recommend checking a few key areas.

    First, confirm that the “Send an email” action is using a valid, licensed mailbox and not an alias or shared mailbox without proper permissions. Also, verify that the recipient email addresses are formatted correctly—extra spaces or missing delimiters can silently block delivery. Next, review the flow’s run history to ensure the email action is executing and not failing or being skipped due to empty data or conditional logic.

    If the Excel table uses dynamic content, ensure the date filter is correctly calculating the upcoming Tuesday relative to the Wednesday trigger. You may also want to add a test email step outside the loop to confirm that the email connector is functioning as expected.

    I hope this helps. Just kindly tick Accept Answer that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    Best regards,

    Domic Vo

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.