Answered

Building a flow to check if a file was modified in the last 30 minutes

(0) Share

Report

Posted on by FreddieV

157

I am building a flow that sends notifies people when a particular file in a Sharepoint document library is modified, which I have working. However, it literally sends hundreds of emails, as I assume it triggers whenever the autosave kicks in.

The best way I can think to minimize the volume of emails is to check if the modified time was within, say... the last 30 minutes using utcNow() and comparing this to the 'Modified' column in Sharepoint? I'm just not sure how the expression would look. Would I need to use:<code>@greater</code> ? Please could I have some help?

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

Paulie78 8,424 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Why not disable that trigger completely and just run the flow on a recurrence schedule and check if the file was updated in the last 60 mins? That would seem simpler to me.

Or run it every half hour and check the last 30 mins.
Jay-Encodian 2,920 on at

Like
a
(0)

Report
Copy link

Link copied!

@FreddieV

agree with @Paulie78 ,that was my first thought.

You could consider SharePoint alerts... you can then just setup to send a daily summary and no need for a Power Automate flow.
FreddieV 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, this does make more sense, but I am still unsure how the expression would look, or even how the fow would now look. How would it check that the document was updated?

I can't see how this would work.
Verified answer

cdn4lf 182 on at

Like
a
(3)

Report
Copy link

Link copied!

@FreddieV you'll need to first get all items within the library.

From there, you'll need to compare the modified date to the utc date - 1 hour

From there, you should be able to send your emails
FreddieV 157 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks very much for your help. Which is the value in the condition....greater than or equal to?
Paulie78 8,424 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I would do something like this:
The output of "Minutes Since Last Modified" can be used in your subsequent conditions. The expression I used was:
div ( div ( mul ( sub ( ticks(utcnow()), ticks(outputs('Get_file_properties')?['body/Modified']) ),100) ,1000000000) ,60 )
Output looks like this:
So you can just follow that with a simple condition like: