Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Email with User Options and Delay Until Reminder

(0) ShareShare
ReportReport
Posted on by 52

I am working on a flow that will send a timesheet reminder every Friday morning. My flow looks like: 

  • Schedule Recurrence 1 time a week on Friday at 9:00am
  • Get my profile (v2)
  • Send email with options with options, "Already Submitted" and "Snooze"

I'm having difficulty on the next part. If the person selects "Snooze", I'd like the email to send a reminder email at 2:30pm EST. 

If I set up a condition where the SelectedObject is equal to "Snooze", then delay until... ---this is where I'm not sure what to put in the timestamp field or anything else I need to initialize or set before sending out the reminder. 

 

  • Verified answer
    DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Email with User Options and Delay Until Reminder

    Just discovered a function.

     

    convertTimeZone(Concat(Formatdatetime(utcnow(),'yyyy-MM-dd'),'T14:30'),'Eastern Standard Time','UTC','yyyy-MM-ddTHH:mmZ')

     

    That gives me 2021-03-03T19:30Z ?

     

    https://support.microsoft.com/en-us/topic/converting-time-zone-in-microsoft-power-automate-8bce2441-1859-4d76-2f51-985d9c96534d

     

  • vlr516 Profile Picture
    52 on at
    Re: Email with User Options and Delay Until Reminder

    I found a sample : addHours(utcNow('yyyy-MM-dd'), 14,'yyyy-MM-ddTHH:mmZ) but didn't know how to make it 2:30 as well as convert then to Eastern Standard Time. 

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Email with User Options and Delay Until Reminder

    Hi @vlr516 

     

    You can specify a delay to a time of day. Delay until.

     

    Concat(Formatdatetime(utcnow(),’yyyy-Mm-dd’),’T14:30’)

     

    this is based on UTC, not sure what your time difference is. You can add hours using addhours expression if need be.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >