Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Wxi8MBqo+TAae1Ho59+KB3
Power Automate - Building Flows
Unanswered

Trying to set up a 3 day reminder to unassigned user requests on sharepoint list

Like (0) ShareShare
ReportReport
Posted on 13 Mar 2024 18:25:01 by 15

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:

MarkLennon01_0-1710354044378.png

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.

MarkLennon01_1-1710354129015.png

 

  • MarkLennon01 Profile Picture
    15 on 19 Mar 2024 at 20:01:38
    Re: Trying to set up a 3 day reminder to unassigned user requests on sharepoint list

    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.

    MarkLennon01_0-1710878469012.png

     

  • MarkLennon01 Profile Picture
    15 on 13 Mar 2024 at 23:22:51
    Re: Trying to set up a 3 day reminder to unassigned user requests on sharepoint list

    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

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 13 Mar 2024 at 18:39:50
    Re: Trying to set up a 3 day reminder to unassigned user requests on sharepoint list

    @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.

     

    Compose Dynamic Date

    Add a Compose action to store a dynamic date. In your case you need to create a date 3 days from today.

    creativeopinion_3-1710355776867.png

    Insert an expression and use the addDays() function. The addDays() function takes three parameters:

    addDays([timestamp],[num days to add/remove],[format pattern])

    creativeopinion_0-1710355644860.png

    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.

     

    creativeopinion_1-1710355670188.png

    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.

    creativeopinion_2-1710355747388.png

    Run a test. Review the output of the Compose action. 

    creativeopinion_11-1710356547624.png

     

     

    Get Items

    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.

    creativeopinion_4-1710356073755.png

     

    Return Item Count

    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.

    creativeopinion_5-1710356196114.png

     

    Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.

    creativeopinion_6-1710356208196.png

     

    Run a test. Review the outputs and ensure the Compose action is returning the correct number of items. 

    creativeopinion_7-1710356289683.png

    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).

    creativeopinion_8-1710356330097.png

    creativeopinion_9-1710356347133.png

     

    Adjust Filter Query

    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.

     

    creativeopinion_10-1710356396171.png

     

    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.

     

    creativeopinion_12-1710356882099.png

    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!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started