evaluating a time window...

(0) Share

Report

Posted on by aking11

Hi there - I have been searching for a solution to my problem. I feel like it should be very simple, but I am stumped!

I am trying to evaluate a timestamp... I want to send a different email based on the time of a form submission. If a form submission is submitted between 12:00AM - 6:00AM i want to send it to a different email address. All other times go to a different email.

This is what i have so far..

Convert the submission time to EST..

Then evaluate the time..

the functions are this:

Converted Time is greater than or equal to

formatDateTime(body('Convert_time_zone'),'yyyy-MM-ddT00:00:00')

Converted Time is less than or equal to

formatDateTime(body('Convert_time_zone'),'yyyy-MM-ddT06:00:00')

help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

lbendlin 8,716 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you only want to compare the hours, right?

Use formatdatetime or startofhour (or both)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @aking11 ,

Please try:

1\

int(formatDateTime(body('Convert_time_zone'),'HH'))

2\

int(formatDateTime(body('Convert_time_zone'),'HH'))

Best Regards,

Bof

Was this reply helpful? Yes No