Flow condition CreatedDate -1 hour

(0) Share

Report

Posted on by KevRichards

Need help. Flow works fine but want to put in a condition for only records created in last hour (or whatever). Can do minus days easily enough.

But applying same for hours doesn't work...e.g. AddHours(utcNow(),-1). Presuming because of formats?

<CreatedOn> field is format yyyy-mm-dd hh:mm:ss.ttt

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Copy link

Link copied!
Hi @KevRichards,

Could you please try to format as below:

addhours(utcNow('yyyy-MM-dd hh:mm:ss.ttt'),-1)

Was this reply helpful? Yes No
KevRichards on at

Like (0)

Report
Copy link

Link copied!

Thanks, I used addHours(formatDateTime(utcNow(), 'yyyy-MM-dd HH:mm:ss'),-1) but that worked too. Seems formatting helps to identify as a time....

Was this reply helpful? Yes No