One single notification for multiple files added in SharePoint

(1) Share

Report

Posted on by VA-31070842-0

Good morning all,

I hope you are well

I would like to create a flow that sends a notification to users (I would use the access column of my SP as there are emails there) when a file or more is added.
However, usually, I receive the files in batches and users may have access to more than one and I don't really want them to receive multiple emails.

So in the event that john smith has access to 2 or more files and is notified, ideally I would like to have only one email sent out.
I am not sure how to get that set up.
Is there any more information you need from me in order to help me?

Thank you

Vincent

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I describe the concept here, in my latest user group presentation located here: Post | Feed | LinkedIn

While my example is using an Excel file, this also works will from a List too. Essentially the key here is the compose action. After getting all the emails from your column you want to use a compose and union() to get your distinct list of emails. This way you are only sending on email.

Then without describing the entire process here, in the apply to each you are going to use a filter array and get the items that match the current item (the current email address) and then send the email.

This works really well and I use it often.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
VA-31070842-0 39 on at

Like (0)

Report

Hello Tom

Thanks a lot for taking the time to reply.

And thank you for the explanation and the link. I will look into it further and try to replicate the logic.

I'll come back to you as soon as I have

Thank you

Vincent

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post one single notification for multiple files added in sharepoint in this category building flows from 01/24/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 2 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
VA-31070842-0 39 on at

Like (0)

Report

Hi trice602,

Thanks a lot for your help and apologies for not following up. To be honest I got stuck and have not managed to adapt your solution to my problem.

I will try again soon though

Vince

Was this reply helpful? Yes No