Hello, has anyone done a flow that allows a set of users to receive an email when a file is created in SharePoint but send only ONE email when multiple files are added at one time? When we test uploading more than one file, an email is sent for each document. I thought maybe we could schedule an email to go out with the folders that had new files added in the last 5 minutes. Or any other suggestions would be appreciated
My suggestion is to implement a recurrence trigger an execute it every 15-30 minutes, you can probably restrict executions to a specific time sschedule (i.e. from 8 am to 5 pm) my configuring its inputs accordingly.
You could probably restrict also executions to week days by means of setting a condition in your trigger settings
Official documentation here
Hope this helps
When I do a schedule, it wants an action not a trigger, how would I put in the send email that it needs to include the path of any folder changed since the last schedule? Without the schedule, here is what my flow is doing.
Let's see if this approach is valid according to your requirements:
I got one email to send, but it doesn't list the new folders that were created in the specified folder path. I am running it by user tomorrow to is if that will work for them. Thank you for your help
Hi, I let the test run overnight to see how many emails came through.
The expression I have in the filter array is (changed it this morning to be 1x a day) but last night it was sent on every hour
"1) Last night, I got an email every hour on the hour even though there were no changes done in the folder path"
The current condition design is not working fine. So my suggestion is, to add a condition an evaluate nr of elements on your Filter array output. Send the email only if more than 0.
So in the left side of your condition rule I would suggest to add the following expression:
on the right side, add a 0
Select 'greater than' as the operator.
Move 'Send an email' to the true branch
Please take a try and let us know if this issue is solved
"2) When I do a test loading two folders with two files in each, it sends me 6 different emails at the same time. "
Is the logic from the last screenshot you shared inside an Apply to each?
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!