You’re offline. This is a read only version of the page.
11
Good Morning Power Users,
I have a complex situation that I'm trying to resolve. We have several issues that we track in a list. I've built a flow to send 30 day and 14 day reminders to the person in charge of remediation. However, there can be multiple people responsible in that column and also multiple issues with the same target completion date. I've found that the flow I've attached is sending multiple emails to each resource for issues that they are assigned and issues they are not assigned. When there are multiple issues due that have the same target completion date I'm receiving emails for issues I am not assigned. How can I get the flow to send emails to the person responsible for remediation column for only issues they are truly assigned?
@jhmorales Instead of using the Apply to Each action to loop through all items in your SP list and run a condition check on each item to see if their anniversary date is today—it's much more efficient to use a Filter Array action. This way you can filter out the items returned from your SP list first before you loop through them.
I cover how to do that in this YT Tutorial: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.
This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:
📅 Student Birthdays
📅 Project Due Dates
📅 Contract/Membership Renewals
📅 License Expirations
📅 Client Anniversaries
IN THIS VIDEO:
✅ How to Send an Email based on a Date Column in SharePoint
✅ Using the Recurrence Trigger in Power Automate
✅How to Use the Filter Array Action with multiple conditions
✅ How to Get Dynamic Content from a Filter Array Action
✅How to Get a Date Three Days from Today
✅ How to Create a Dynamic Date Based on utcNow()
✅ How to Return a Count of Items
✅ How to initialize and set a variable
✅ How to use the Send an Email (V2) action
✅ How to send test emails
-----
Since you've stated that you have multiple people assigned to an item, you will also find this YT Tutorial helpful:
You might find my YT Tutorial helpful: How to Handle Multi-Person SharePoint Item Notifications in Outlook and MS Teams with Power Automate
Do you want to know how to send an email to all users assigned to a SharePoint item? If so—this Power Automate tutorial is for YOU 🫵.
In a previous YouTube tutorial I covered how to build a Power Automate flow that sends a single email to each user with the tasks assigned to them.
However, that tutorial only covered a scenario where each task is assigned to a single user. What if your task is assigned to more than one user?
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
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
