Power Platform Community Forum Thread Details

Hello-

I have a Flow set up to post a message to a Teams channel whenever a certain file is updated in SharePoint. The trigger is "When an item or a file is modified" and then the Flow checks if the name of the file that was modified matches the one that I'm interested in, and sends a message if it is but does nothing if it's not. The file in question is a spreadsheet that is being used to collect data over time, and it is dumped in chunks as it is created. This has been working very well, but there is a small issue when it comes to multiple small modifications made in sequence. For example, if I copy and paste a chunk of data into the sheet and then immediately go and enter the date in another cell it tends to create 2 separate notifications (although not always). I'm really only looking to track when the data dumps at large are made, and so am looking to set up a situation where the flow only sends a notification if the file was modified after a certain number of minutes. For example, if multiple edits are made within, say, a 5 minute period (this is flexible) then they would be ignored by the Flow but after that period had expired it would start sending messages again.

The limiting factor doesn't have to be time; I'm just looking to avoid getting notifications for every single small edit made in succession. I would like to use Power Automate/Teams because I need to automatically notify people in multiple organizations and departments and they are all in this Team (and also I like the dynamic content) but if similar functionality can be replicated elsewhere I am also open to that.

Thanks for the help in advance!

Categories:

General topics