Hello,
I have a sharepoint list which receives data from an ms form via a power automate flow.
Each row of data should then be assigned to someone.
I want to send an email reminder to the user group (Automation Team) if a request has been for 3 days and remains unassigned. The flow works up to the point of sending an email.
Can anyone help? Many thanks. Mark
This is the flow:
The error message for Send an email (V2) is: "ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied."
The SP list screenshot is as follows: You can see that Status = New request and Assigned To (called Owner originally) is null. These were the two conditions.
I had to update the Filter Query to reflect the 3 internal field/column names for the Filter query and this helped resolve it, along with some info from A Creative Opinion.
Hi "A Creative Opinion" - thanks a million for all this amazing info. Seriously 🙂
I shall work through this and come back to you. Although it is a 3 day reminder, I was trying this 'addMinutes(utcNow(), -1)' within Compose so that I could see if it works. I suspect the flow was close to being fine but something in my SP list was preventing the email being triggered (an incorrect column perhaps?). I will get back to you. Thanks again. Mark
@MarkLennon01 You can apply similar concepts covered in the tutorial linked at the bottom to your flow. First, I would recommend you use the Classic Designer as the New Designer still has a few bugs.
I would start with just the Recurrence Trigger and the Get Items action. You'll need to ensure your Filter Query is returning items you'd like to loop through. It's best practice to test out the filter query in the Get Items action before you try to even loop through the items. You might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
IN THIS VIDEO:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent
When you say request has been for 3 days and remains unassigned are you evaluating the date the SP Item was created? If this is the case, you'll need to use a Filter Query to check if the created date is older than 3 days and is unassigned.
Add a Compose action to store a dynamic date. In your case you need to create a date 3 days from today.
Insert an expression and use the addDays() function. The addDays() function takes three parameters:
addDays([timestamp],[num days to add/remove],[format pattern])
Insert the utcNow() function into the addDays() function. This will return the current date and time. Add a comma and a number. Use a negative number to subtract days or positive to add days. In your case use a -3.
For the format pattern, you'll need to insert a time that suits your requirements. The created column stores a date and a time. In my case I'll use 00:00:00 which will be 12am. You'll have to adjust this to suit your needs.
Run a test. Review the output of the Compose action.
First, compose the Filter Query to only return items with a created date le (less than or equal to) or lt (less than) your dynamic date. Ensure you have the dynamic content in between single quotes.
Whenever I use a Filter Query in a Get Items action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.
Insert a Compose action. Add an Expression. Use the length() function.
Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.
Run a test. Review the outputs and ensure the Compose action is returning the correct number of items.
Keep in mind, depending on how many items you have in your SharePoint list you may need to turn on Pagination and set a Threshold in the Get Items action as this action will max out at 100 items by default (unless you turn on Pagination and set a Threshold).
Adjust your filter query to include additional conditions. I would recommend running a test each time you add a new condition. You will need to use the internal column name of the columns you use in your filter query. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.
Run a test. Check the output of the Compose action.
Add another condition and run another test. Note: I've changed my status to an option that actually exists in my list.
Run another test. Check the output of the Compose action.
Now that you have a list of filtered items, you can add the Apply to Each action to your flow.
----
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
Hope this helps!
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional