Delay until specific time every day

(0) Share

Report

Posted on by dannyfarrington

Hi all

I have a flow set up which used Microsoft Forms:

> When a response is submitted

> Get form responses

> Get user profile

> Send an email from a shared mailbox

The email will pull the form responses and send them to the employee and their manager.

The form is completed throughout the day, every weekday.

I need the email to the employee to only be sent between 3:00pm and 5:00pm - anything prior to 3:00pm is delayed, anything after 5:00pm waits until 3:00pm the next day.

Is this possible at all?

Cheers

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-duann-msft on at

Like (1)

Report

Hi @dannyfarrington

Thank you for posting.

According to your description, you would like to send email only during 15:00-17:00 everyday. For other response, you would like to delay them until 15:00-17:00. If any misunderstanding, please kindly let me know.

If that’s the case, we need to use ‘condition’’ and ‘delay until’ action. Here is the flow for your reference:

convertTimeZone(outputs('Get_response_details')?['body/submitDate'],'UTC','China Standard Time','HH:mm:ss')

formatDateTime(addHours(formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd'),15),'yyyy-MM-ddTHH:mm:ssZ')

As we have timezone issue here, so we need to use convertTimeZone function to convert UTC to your region. In my example, I use ‘China Standard Time’ as I located in (UTC+8). You may need to modify expression as required.

To check timezone expression of your region, please go to below website:

Default Time Zones | Microsoft Docs

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Hope the content above may help you.

Best regards,

Anna

Was this reply helpful? Yes No
BMP 18 on at

Like (0)

Report

Hi Anna,

I've copied your flow, but it doesn't appear to be working for me, could you help me please?

I modified the expression to the following -
convertTimeZone(outputs('Get_response_details')?['body/submitDate'],'UTC','GMT Standard Time','HH:mm:ss')

I'm located in the UK and working on current GMT+1 daylight savings time zone.

What would you recommend I do? I'm running my flow to send out certificates during 15:30 and 17:00 every day, regardless of when the form was created.

It says the expression result was false.

Was this reply helpful? Yes No