Power Platform Community Forum Thread Details

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

Categories:

Using flows

@Alc:

Here are two options for you:

Create a Flow using a recurrence trigger that runs once a day.
1. User a Get Files action and loop through each document
2. If the last modified time is within the last 24 hours then post a message to Teams.
3. 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.
1. Initially, store the last update date/time in the column (set when document is created)
2. When a document is updated, compare the value of the new Date/Time column with the modified column
  1. If difference is less than 24 hours, do nothing
  2. If difference is greater than 24 hours, then
    1. Set new date time column to value of modified column
    2. Post message to Teams