Unanswered

If Sub before a time this then that

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (5)

Answers (0)

Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report
Re: If Sub before a time this then that

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.
Community Power Pla... on at

Like (0)

Report

Re: If Sub before a time this then that
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report

Re: If Sub before a time this then that

Hi @Anonymous,

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

Like (0)

Report

Re: If Sub before a time this then that

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?
Expiscornovus 31,635 Most Valuable Professional on at

Like (0)

Report
Re: If Sub before a time this then that

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')