web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : kfSEw7k0EdZDP8t11K4Bcn
Power Automate - Building Flows
Unanswered

Can somebody please assist as to why this flow will not send the email when I test?

Like (0) ShareShare
ReportReport
Posted on 27 May 2024 05:16:01 by 6
 
Reaper_4-1716786878955.png

 

Here is the Spreadsheet it is pulling data from

 
Reaper_3-1716786855946.png

 

Here is the flow with the condition function highlighted. I just want an email sent when the "ReminderEmail" date arrives. Thank you.

I have the same question (0)
  • v-yetonggu-msft Profile Picture
    on 27 May 2024 at 06:35:52
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Hi @Reaper ,

    Please check this test:

    My Flow Overall Preview:

    vyetonggumsft_0-1716791503709.png

    My Flow Configuration Parameters:

    Do not choice any DateTime Format in List rows present in a table:

    vyetonggumsft_2-1716791691068.png

    ReminderEmail ne '@{null}'
    addDays('1899-12-30',int(item()?['ReminderEmail']),'yyyy-MM-dd')
    utcNow('yyyy-MM-dd')

    Best Regards,

    Sunshine Gu

  • Reaper Profile Picture
    6 on 27 May 2024 at 05:59:32
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Reaper_0-1716789523845.png

    Reaper_1-1716789546383.png

    There is a lot more, please let me know if you want me to keep screenshotting

     

  • v-yetonggu-msft Profile Picture
    on 27 May 2024 at 05:55:36
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Hi @Reaper ,

    What is the error message in your flow? Please go to the classic designer to run the flow, and then please upload a screenshot of the output of your list rows present in a table to me.

     

    Best Regards,

    Sunshine Gu

  • Reaper Profile Picture
    6 on 27 May 2024 at 05:53:05
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Unfortunately it has failed again

     

    Reaper_0-1716789174467.png

     

  • v-yetonggu-msft Profile Picture
    on 27 May 2024 at 05:44:26
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Hi @Reaper ,

    Please use this expression in condition left:

    if(empty(items('Apply_to_each')?['ReminderEmail']),null,items('Apply_to_each')?['ReminderEmail'])

    Best Regards,

    Sunshine Gu

     

  • Reaper Profile Picture
    6 on 27 May 2024 at 05:40:17
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    I have completed these steps but still no email unfortunately

     

    Reaper_0-1716788372678.pngReaper_1-1716788400967.png

     

  • v-yetonggu-msft Profile Picture
    on 27 May 2024 at 05:32:05
    Re: Can somebody please assist as to why this flow will not send the email when I test?

    Hi @Reaper ,

    Please select ISO 8601 in DateTime Format in the list rows present in a table control, and then use this expression on the right side of condition:

    utcNow('dd/MM/yyyy')

    Best Regards,

    Sunshine Gu

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2