Unanswered

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

I have the same question (0)

All responses (6)

Answers (1)

Paulie78 8,422 Moderator on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report

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

@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.

Was this reply helpful? Yes No
FreddieV 157 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Verified answer

cdn4lf 182 on at

Like (3)

Report

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

@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

Was this reply helpful? Yes No
FreddieV 157 on at

Like (0)

Report

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

Thanks very much for your help. Which is the value in the condition....greater than or equal to?

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

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

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:

Was this reply helpful? Yes No