@garethbeverland Take a look at this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
Although I cover how to send a single email of multiple SharePoint list items—the same concept can be applied when working with files in a document library. Instead of the Get Items action, you'll need to use the Get Files (properties only) action.
Fun fact. The Get Files (properties only) action returns files and folders. To return files only, check out this YT Short.
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
Since it looks like your Owner column can assign more than one user. You'll need to also reference this YT Tutorial: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate
The tutorial linked above only covers a scenario where each task is assigned to a single user. Again, this tutorial covers how to work with items in a SharePoint list—however, you can use the same concepts covered in the video for your flow.
In this Microsoft Power Automate tutorial I’ll cover how to create a flow that is triggered by selecting an item. This automation will send an email to all assigned users for the selected task. I’ll also show you how to adjust your flow so that you can send a message in Teams. Then I’ll show you how to collect a list of unique users that have been assigned to multi-person tasks. Using this concept, we’ll edit the flow from the previous tutorial so that it works with a multi-person column.
IN THIS VIDEO:
✅ How to trigger a flow from a selected file
✅ How the multi-person column data outputs
✅ How to use the Select action to get all assigned to users of a SharePoint item
✅ How to use the Join action to convert an array of email addresses into a string
✅ How to send a single email to all assigned to users of a SharePoint item
✅ How to send an email to each assigned to user of a SharePoint item
✅ How to send a Teams message to each user assigned to a SharePoint item
✅ How to return a list of unique users from the multi-person column in a SharePoint list
✅ How to use a Filter Array action to return all SharePoint list items assigned to each user
✅ How to group Power Automate actions together with the Scope action
✅ How to edit a previous flow
Hope this helps!
