Unanswered

If Sub before a time this then that

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to send a specific email if the submission occurs prior to 1 pm EST and if it is submitted AFTER 1 pm another message will be sent.

Essentially, if a user submits a request prior to 1 PM the team will get to it the same day; but if it is AFTER 1 pm it will be done before 1 pm the following day

I don't know how to do this condition on flow

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

You could use an expression and format the datetime field with the HH (24 hour format). You can check if it is less than 13. If that is the case it will be processed today.

Below is an example of that approach:

In my example I used the utcNow function. Replace that by your datetime field and use for example the formatdatetime instead.

if(less(utcNow('HH'),'16'), 'Today', 'Tomorrow')

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Could I see an example? I don't know exactly on what action this would go? And do I have to format the time prior to?

Was this reply helpful? Yes No
Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Can you share a screenshot of your current flow setup? This way I can adapt an example to your specific situation.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Expiscornovus 33,846 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

In your setup it would be something like:

less(formatdatetime(outputs('Get_response_details')?['body/submitDate'], 'HH'),'13')

is equal to

true

Btw, you might need to update the 13 to a different number because it looks like submission time (submitdate) of Microsoft Forms is UTC and not your time zone. So, definitely double check that.

Was this reply helpful? Yes No