File Upload Notification Flow

(0) Share

Report

Posted on by EMKody

147

Hi all,

I currently have a flow setup so that each time a file is uploaded to a SharePoint library, an email and Teams message is sent to the file 'owner', which is represented by a people column I created in the table. What we have found is this can be quite problematic if many individual files are uploaded at once, as both a Teams message and email is generated for each file. How could I edit this flow so that I can still send an email that is segmented by owner, that shows a list with a path to all files that were uploaded within the past hour? Ideally the notification would look/function something like this:

New content has been posted:

[Association Name] - [Publication Name] - *Link to content*

*Link to library*

Categories:

Building flows

notification flow...

I have the same question (0)

All responses (3)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@EMKody Since multiple files can be uploaded at once, have you considered using a recurrence trigger instead? This way you can set the flow to run at an interval you set (eg. every 15 mins).

I would also recommend adding a custom column to track whether a Teams message has been posted for a file or not. This could be a Yes/No or Date column (any column really.. up to you)

You can refer to this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Although, this tutorial specifically covers how to send an email with multiple SP items, the concepts covered in this tutorial can apply to your flow.

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
EMKody 147 on at

Like (0)

Report

Hey @creativeopinion,

First off, hats off to you for your YouTube content. I have already watched several of your videos and subscribed! Love the style and how thorough they are. I am wondering though what your thinking is with the yes/no column for Teams, and how you would use it.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@EMKody Thanks for watching and subscribing. Sorry for the misunderstanding. I was suggesting you add a Yes/No column to your document library to track which files you've already posted about in Teams. This way you could use a recurrence trigger instead to check your document library on an interval.

Was this reply helpful? Yes No