Answered

AddMinutes condition not reading Converted Time

(0) Share

Report

Posted on by ianhillmedia

Hello all!

I'm writing a Flow that scrapes an API for data that includes a timestamp. If the timestamp is within the last 30 minutes, the Flow should post a message as Flow bot to a Teams channel.

Time is displayed in the API as a 12-digit string in U.S. eastern time; I'm converting it to UTC in my Flow, which is testing successfully.

I then have a conditional: If converted time is greater than AddMinutes(utcNow(),-30), post the message to the Teams channel.

That conditional is not working. Even when the timestamp in the API is within the last 30 minutes, the conditional comes back as false. It never posts the message.

I've tried the conditional two ways; you can see that plus the output of converted time and how I'm converting time in the screenshots below.

Any guidance would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

It should definately be the second way of doing it. The parameter for UTCnow() is the format pattern you want, not the time. In your first try you are feeding it the converted time, not a format pattern.

So the second set of code looks correct. But could you show us an actual run of the flow with a compose to show the output of the time conversion and the addminutes() function? That way we can see what is actually being compared. That will probably identify why its not working.

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @ianhillmedia ,

Please check to ensure the format of both dates are in the same format.

I am not in front of my pc but try formatting the utcnow() into the same format.

As mentioned above, please post the data from your run.

Was this reply helpful? Yes No
ianhillmedia 41 on at

Like (0)

Report

Sure! Any guidance would be appreciated. In this case I used AddMinutes(utcNow(),-90), just to make sure there was data from the API to capture. Screenshots below. Let me know if I can provide anything else that would help! FYI it's 12:30 p.m. ET, whichis 4:30 p.m. UTC right now. THANK YOU!

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

That shows the converted time. But can you also add a compose just before the condition and use the same AddMinutes() function as in the right side of the condition. Then we can see what is actually being compared. The converted time is in ISO 8601 format and the add minutes should default to that format as well, so I don't think formatting is the issue. We need to make sure the AddMinutes is putting out the time you think it is.

Was this reply helpful? Yes No
ianhillmedia 41 on at

Like (0)

Report
Done! So here's what I get when I Compose:

addMinutes(utcNow(body('Convert_time_zone')),-90)

I also Composed:

addMinutes(utcNow(),-90)

And got

In both cases, the condition still returned...

THANK YOU for your help!

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Try this. Got it working in mine.

formatDateTime(addMinutes(utcNow(),-30),'yyyy-MM-dd HH:mm:ssZ')

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Add a formatDateTime() function around the addminutes() to make sure its in same format as the adjust time zone. Use this format. 'yyyy-MM-dd hh:mm:ssZ'

Was this reply helpful? Yes No
ianhillmedia 41 on at

Like (0)

Report
No luck, unfortunately.

I used:
formatDateTime(addMinutes(utcNow(),-60),'yyyy-MM-dd HH:mm:ssZ')

Results below.

Was this reply helpful? Yes No
ianhillmedia 41 on at

Like (0)

Report

And here's a weird rub. This — expression less than Converted Time — always returns the condition as false, no matter what. It should return true when Converted Time is within 60 minutes.

Meanwhile, this — expression greater than Converted Time — always returns as true, even when Converted Time is within 60 minutes and it should be false.

Was this reply helpful? Yes No
ianhillmedia 41 on at

Like (0)

Report

Not having any luck, unfortunately. See below.

Was this reply helpful? Yes No