Answered

Obtain information at a specified time interval

(0) Share

Report

Posted on by d4n13l74

Hello. Thanks for reading me.

Iam making a query to an API where I get information.
Performing the query, I get the creation date field of a file in this format.

yyyy-MM-dd hh:mm:ss : 2021-11-30 04:17:11

I need to make queries every 1 hour where I can fetch everything created from the query time until one hour before, that is from 2021-11:30 04:17:11 to 21-11-30 05:17:11 .

I already get the current time and the time 1 hour ago. I don't know how to put the condition to say if the creation date is in the range of 21-11-30 05:17:17:11 and 21-11-30 04:17:11.

Thanks

All responses (4)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Obtain information at a specified time interval

Hi @d4n13l74

Has your problem been solved?

You can use Condition to determine whether the creation time is within a certain interval.

In order to facilitate the test, I added Compose action and rename the action and put the creation time, the current time and the time 1 hour ago in the Compose action. And make sure their format is consistent.

Result:

Hope the content above may help you.

Best Regards
VictorIvanidze 12,505 on at

Like (0)

Report

Re: Obtain information at a specified time interval

https://powerusers.microsoft.com/t5/Building-Flows/Compare-dates/td-p/54802
d4n13l74 17 on at

Like (0)

Report

Re: Obtain information at a specified time interval

Thank you @VictorIvanidze . What do you mean by Convert all time data/values to ticks?
VictorIvanidze 12,505 on at

Like (0)

Report

Re: Obtain information at a specified time interval

Convert all data/time values to ticks and compare them as numbers.