Obtain information at a specified time interval

Like (0) Share

Report

Posted on 30 Nov 2021 16:07:07 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

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (4)

Answers (1)

Verified answer

v-LilyW-msft on 06 Dec 2021 at 06:58:45

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

Was this reply helpful? Yes No
VictorIvanidze 12,601 on 01 Dec 2021 at 13:28:53

Like (0)

Report

Re: Obtain information at a specified time interval

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

Was this reply helpful? Yes No
d4n13l74 17 on 01 Dec 2021 at 11:49:57

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?

Was this reply helpful? Yes No
VictorIvanidze 12,601 on 01 Dec 2021 at 08:28:06

Like (0)

Report

Re: Obtain information at a specified time interval

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

Was this reply helpful? Yes No