Email with User Options and Delay Until Reminder

(0) Share

Report

Posted on by vlr516

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
vlr516 52 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No