Condition - check if flow already ran today

(0) Share

Report

Posted on by Alc

Hi all,

I have a flow which triggers on "When a file is created or modified in a folder" for a sharepoint file and will post a message to teams to say the file has been updated. I've found that due to the autosave on word online (editing via teams) that the flow triggers multiple times whilst it is being edited. How can I add a condition or something to ensure it is only triggered once a day?

Many thanks

Paul

All responses (1)

Answers (1)

Verified answer

ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report
Re: Condition - check if flow already ran today

@Alc:

Here are two options for you:

Create a Flow using a recurrence trigger that runs once a day.

User a Get Files action and loop through each document

If the last modified time is within the last 24 hours then post a message to Teams.

Alternatively, you could use an ODATA filter in the Get Files action to return only those files that meet your criteria

Add a column a date/time column to the library.

Initially, store the last update date/time in the column (set when document is created)

When a document is updated, compare the value of the new Date/Time column with the modified column

If difference is less than 24 hours, do nothing

If difference is greater than 24 hours, then

Set new date time column to value of modified column

Post message to Teams

If this addresses your issue, please mark your Post as Solved.

Scott