Unanswered

Troubles with time condition

(0) Share

Report

Posted on by louisquinet

Hi!

I want to build a flow where every page of my site library is checked with the condition "Has it been modified in the last 2 hours?". If yes, I want to receive an email for every page.

I tried this:

(dynamic content) "Modified" is greater than (expression) formatDateTime(addHours(utcNow(),-2),'yyyyMMddThh:mm:ssZ')

But it does not work unfortunately, I only receive an email for 4 pages instead of +/- 40. I added the formatDateTime because "Modified" and utcNow() are not in the same format. You can find a screenshot of my flow bellow.

What do I do wrong?

Thank you in advance

Louis

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @louisquinet
Try this expression in order to get the time difference between two dates
div(sub(ticks(outputs('yourStartDateTime')),ticks(outputs('yourEndDateTime')),600000000)
ticks will convert dates into numbers.

Hope this helps
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
louisquinet 50 on at

Like (0)

Report
Copy link

Link copied!

Hi @abouchaalaBAIT ,
Thank you for your fast response!
I do not completely understand where/how I need the use your expression.
What do I replace by 'yourStartTimeDate' and 'yourEndTimeDate'.
Where does the '600 000 000' in the expression stand for?
Where do I have to place this expression on my flow.
Sorry I am a beginner at Power Automate...
Thank you!
Louis

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!
No worries, I think you will better understand with those screenshots
Here is the item that I created 29 minutes ago
And here is my test flow

I'm getting the item with ID 9 and trying to get the time difference
using this expression
div(sub(ticks(outputs('Get_item')?['body/Modified']),ticks(utcNow())),600000000)
outputs('Get_item')?['body/Modified'] : yourStartDate
utcNow() : yourEndDate
ticks function : convert dates into number
sub : to get the difference
div : in order to get the minutes

in your case, all what you have to do next is to add a condition and compare between the difference and 120 minutes

Hope this helps
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
louisquinet 50 on at

Like (0)

Report
Copy link

Link copied!

Hi @abouchaalaBAIT,
I tried to do it with the expression: div(sub(ticks(outputs('Get_files_(properties_only)')?['body/Modified']),ticks(utcNow())),600000000) but I receive an error message when I run it.
I changed 'Get_Items' by 'Get_files_(properties_only)' because I use this action in my flow. Is there a problem with this or is it something else?
You can find a screenshot of my flow and the failed run of the flow bellow.
Thank you for your help
Louis

The failed run:
The flow:

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!

use Get file properties instead of Get_files_(properties_only)
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No