cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
willtickel
New Member

Send only one email notification when a file is added or modified

I've got a standard flow that notifies me and my client when files are added or modified in a SharePoint file and also refreshes a PBI dataset.

 

Every month there will typically be 5 new files added and ideally I'd like there to be a single email with a summary rather than 5 individual emails I'm currently getting. 

 

Anyone got any idea of how best to accomplish this?

 

Many thanks, 

willtickel_0-1608731232589.png

 

 

1 REPLY 1
Pstork1
Dual Super User
Dual Super User

To do this as one email you'll have to switch the trigger to a recurrence trigger that fires once a month rather than a trigger that fires everytime a file is created or modified.  Then do a get Files (properties Only) after the trigger and use a filter array to filter out any file that wasn't modified in the last 30 days.  Use a loop to gather the information on the files into a variable and then send the email.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,689)